May 10, 2007 at 8:32 pm
Question from someone new to 2005. I have a Full backup from SQL 2000 (v. 8). How can I bring that over to the new server with SQL 2005 and easily import the DB? I tried several methods already. I tried exporting the 2000 DB into Access and then importing into 2005. Thanks in advance (desperate to get things up and running -- great forum site, by the way!).
May 10, 2007 at 9:22 pm
you should copy the backup files to new server. Now, try restoring it on the new databases. see if that works.
May 10, 2007 at 11:45 pm
Just backup the database from the 2000 server and restore the backup file in sql server 2005. this should be doing fine for your requirement.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply