May 29, 2012 at 12:22 pm
I have an old server I was using to experiment with SQL 2000 a few years ago. It was the Evaluation version which has long since expired. The SQL service will not start, but I'd like to move the DB files to SQL 2008.
How might I do this?
1) Reset the system data or some other trick to temporarily get SQL 2000 to run, then run backups?
2) Install MSDE 2000 (still available from Microsoft download site), attach the data files, backup.
3) Copy the SQL 2000 MDF & LDF files to my SQL 2008 machine and attach them?
Next, it is my understanding that SQL can restore\upgrade backups from two major version back, so SQL 2008 can restore backups created on SQL 2000. So SQL 2000 backups CANNOT be restored on SQL 2012, correct? What about 2008 R2?
May 29, 2012 at 10:29 pm
dan-572483 (5/29/2012)
3) Copy the SQL 2000 MDF & LDF files to my SQL 2008 machine and attach them?Next, it is my understanding that SQL can restore\upgrade backups from two major version back, so SQL 2008 can restore backups created on SQL 2000. So SQL 2000 backups CANNOT be restored on SQL 2012, correct? What about 2008 R2?
Copy database files to new machine and attach them... this method is easier than other methods.
After attaching you need to run DBCC UPDATEUSAGE.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply