pinniger Asked: 2010-01-06 08:14:36 +0800 CST2010-01-06 08:14:36 +0800 CST 2010-01-06 08:14:36 +0800 CST sql server backup 772 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. sql-server 1 Answers Voted Best Answer squillman 2010-01-06T08:39:06+08:002010-01-06T08:39:06+08:00 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.
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.