March 13, 2003 at 1:22 pm
Hi
I have a .bak file of a database from a sql 7 server that I need to restore to my sql 2000 server. Is this possible - I just get errors!
If its not possible, what is the best way of getting a copy of the sql7 database onto my sql2000 server? We don't have a network connection or ftp access so would have to work via cd.
I'd really appreciate any help - I'm new to this and feeling a bit bamboozled!
Wendy
March 13, 2003 at 1:34 pm
There are several ways. First choice, you could upgrade your SQL server 7 to 2000 (or other server) backup the db, ans restore it in the SQL 2000 server.
Second you could generate .txt files with bcp of every table in the SQL 7 server, and then bulk insert it into your sql 2000 server prior creating the database.
Or generate a DTS package to import the data to the 2000 server.
March 16, 2003 at 2:09 pm
Thanks for your help. I'm pretty new to SQL Server. How would I go about generating a DTS package?
Wendy.
March 17, 2003 at 8:51 am
What type of errors are you getting ?
I restore 7 to 2k all the time, we are migrating slowly to 2k, and I have to restore them for testing. Never seen a problem.
Sometimes it is better to create a dummy DB on the new server to restore into, with the "Force over ... " option.
Don't forget to reset the users.
KlK, MCSE
KlK
March 28, 2003 at 11:09 am
Hi !
You should be able to restore SQL Server 7.0 backups to SQL Server 2000. You don't need to upgrade your SQL Server or anything. It is supported by SQL Server 2000 (But u can not restore SQL Server 2000 to SQL Server 7.0). What error are you getting ?
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply