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.
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
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.