May 1, 2006 at 11:41 am
I have a sql 2005 backup that I am trying to restore in sql 2000. I get the following error..
Error:3169 The backed up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. Restore filelist is terminating abnormally.
Is there a workaround for this?
Catherine
May 1, 2006 at 2:03 pm
You can not restore database structure for 2005 on the 2000 server because of a difference in the system table structure.
Workaround: restore 2005 to 2005 server and use DTS to copy tables and other objects.
Regards,Yelena Varsha
November 25, 2006 at 7:51 pm
According to Microsoft, you can restore SQL 2005 databases on SQL 2000 if SQL 2000 has SP4. I haven't been able to make it work, though. If anyone has a suggestion, I'd appreciate it.
Here is what Microsoft says: "Media that is formatted with SQL Server 2005 cannot be interpreted by SQL Server version 7.0 and releases of SQL Server 2000 before SP4 because of changes in the media header. However, SQL Server 2000 SP4 supports the SQL Server 2005 media header."
The reference is as follows:
November 26, 2006 at 1:48 am
You CANNOT restore SQL 2005 backup to SQL 2000.
Media is not backup.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply