up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
feedback

1 Answer

up vote 4 down vote accepted

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.

link|improve this answer
I'll add that you can get a 60 trial version of SQL 2008 from MSFT's website. – user18330 Jan 5 '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 5 '10 at 18:32
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.