DB transfer prob
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21083
Printed Date: 09 April 2026 at 4:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: DB transfer prob
Posted By: Mental_Merlin
Subject: DB transfer prob
Date Posted: 19 August 2006 at 10:54pm
|
First ive done a search for this,but not found any answers, so appols if ive missed it.
I have been using your forums now at http://www.mercilesscreations.net/forum - www.mercilesscreations.net/forum for over 2 years with no problems.
But now Im moving host, so i requested a db backup, which i got, but it was as a .bak file.
I reinstalled your 7.9 at my new host, all went fine, np..
But when i go into the programme that the provider supplies for accesing the MSSQL, I can see the db he has created, and the files that 7.9 has uploaded to it. (nd, i cannot rename, or name the db the provider gives me)
So i can navigate to the CSV import wizard, then it goes to "Select the table into which you want to import data :"
So as I have one .bak, I dont have sep tables to install, and i cannot click multiple tables.
My intention is to be happy about transfering the old forum tothe new server, get it working, then upgrade to version 8.
Any help appreciated.
MM
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 20 August 2006 at 8:44am
|
What you would normally do when transferring an SQL Server database is to use Enterprise Manager of SQL Server Management Studio to transfer the database to the new server. What your host have done is backedup the SQL Server database and just given you a back up file. If you can't use Enterprise Manager of SQL Server Management Studio to transfer the database, the you will need to use Enterprise Manager of SQL Server Management Studio, login into your database and select 'Restore' the database from the backup file. If you are having problems with this it maybe worth asking your new web host to do this restore for you. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Mental_Merlin
Date Posted: 27 August 2006 at 12:00pm
|
Im still having probs, and my isp is not really helping, its all back to the.bak file again..
Here is what I have access to,
Because it is in .bak, ive no idea how to place/insert it, ive tried with various combos, but every time it corrupts the forum
    |
Posted By: WebWiz-Bruce
Date Posted: 28 August 2006 at 9:01am
|
I've never seen the software you are using as you would nor normally use Micrsosft Enterprise manger or their new SQL Server Management Studio. If your host are not being much help I would find a better host who can be help. Also, try the support for the SQL Admin software you are using as to how to use .bak files with it, as I have never come across this software before. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |