After upgrading SQL Server from SQL 2000 to SQL 2005, unable to restore SQL 2005 Database to the server. Get an error in SQL Management Studio that states "The backed-up dat...

[Product_Support]

Issue

After upgrading SQL Server from SQL 2000 to SQL 2005, unable to restore SQL 2005 Database to the server. Get an error in SQL Management Studio that states "The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database."

Environment

SQL Server 2000

SQL Server 2005

Continuum

Cause

Both SQL2000 and SQL2005 versions of the SQL service were installed and running on the server. When restoring the database it was trying to restore an SQL2005 database to an SQL2000 server, which is not supported by Microsoft.

Resolution

1. Un-install SQL2005
2. Un-install SQL2000
3. Re-install SQL2005.