-
Título
Error: On-disk structure backup version 611. Server supports version 539 -
Descripción
Full error message: The backup database has on-disk structure backup version 611. The server supports version 539 and cannot restore or upgrade this database.
This error occurs when restoring SQL Server 2005 backup to SQL Server 2000.
However, this error may also occur when SQL database was detached from SQL Server 2005 and re-attach to SQL Server 2000 database.
For more information, see:
http://www.tek-tips.com/viewthread.cfm?qid=1207530&page=1
https://www.microsoft.com/en-US/search/result.aspx?setlang=en-US&q=on-disk+structure+backup+611+539 -
Causa
This causes SQL Server version and database level incompatibility. Compatibility Level: SQL 2005 (90) and SQL 2000 (80). -
Resolución
Other possible options to consider:
You can script and transfer the data using SMO (or Copy Database Wizard).
You can replicate the data from SQL Server 2005 to SQL Server 2000.
You can keep the databases in SQL Server 2000 and continue to use the SQL Server 2005 tools.
Keep the database in SQL Server 2005 with database compatibility mode at 8 so other applications can continue to access the database.