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.'
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.
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.
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.
