-
Title
Unable to restore a backup on a SQL Server 2008 database, if the backup was made on a SQL Server -
Description
When trying to restore a backup made on a SQL Server 2008 R2 database, onto a SQL Server 2008 database, the following error appears:
'Unexpected termination on thread: 1, Return code: x80770004
RESTORE DATABASE is terminating abnormally. The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.'
-
Cause
The SS2008 R2 backup can not be read by the SS2008 database, as it has been created from a 'future' version of the database.
There’s no backward compatibility between SQL server versions when doing a restore.When the database is created in SQL server, it’s given a internal dbversion that depends on the version of SQL server. Based on dbversion SQL Server identifies if the backup was created with a different version of a SQL Server. Though the version names for “SQL Server 2008” and “SQL Server 2008 R2” look similar, the dbversions in their databases are different (660 for 2008R2 and 655 for 2008), and that’s why the restore doesn’t work. -
Resolution
The database would need to be updated to the same version as the backup.
This is a Microsoft limitation rather than a LiteSpeed imposed issue.
-
Additional Information
Copying Databases with Backup and Restore
“SQL Server 2008 R2 backups cannot be restored by any earlier version of SQL Server.”RESTORE (Transact-SQL)
“Backups created with Microsoft SQL Server cannot be restored to an earlier version of SQL Server.”
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/45be2608-4563-4a3a-8a3a-51a9e030c051/
The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600.
Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.