Is there any way to to restore a backup created on sql server 2005, onto sql server 2000?
Edit: all I have is the .bak file, no access to the original database.
Asked
Active
Viewed 57 times
1 Answers
4
Unfortunately, no. The database formats are incompatible. You should be able to restore it to a SQL 2005 instance and then copy it to the 2000 instance via the copy db wizard.
squillman
- 37,618
- 10
- 90
- 145
-
I'll add that you can get a 60 trial version of SQL 2008 from MSFT's website. – user18330 Jan 05 '10 at 16:43
-
Yeah, or SQL Express for free if all you need is something to restore to. And as long as the db is small enough. – squillman Jan 05 '10 at 18:32