-
Title
SQL Restore failed; the backup of the system database on the device cannot be restored because it -
Description
When trying to restore a Database within a previous backup to a current SQl Server version 2008 SP3, the restore fails.
-
Cause
When trying to restore a Database within a previous backup to a current SQl Server version 2008 SP3, the restore fails.
Symtoms:
Error Date/Time 474 Data Plugin Servername Unexpected termination.
Error Date/Time 474 Data Plugin Servername ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The backup of the system database on the device BAKBONE3980 cannot be restored because it was created by a different version of the server (10.00.4064) than this server (10.00.5500).
Error Date/Time 474 Data Plugin Servername ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally.
Error Date/Time 474 Data Plugin Servername The SQL VDI command failed.
Error Date/Time 474 Jobs Servername Fatal error: Restore failed
Error Date/Time 474 Jobs Servername Job Status: Restore Failed
SQL version 10.00.4064 is (SQL Server 2008 SP2).
SQL version 10.00.5500 is SQL 2008 Service Pack 3 (SP3).
Cause; The database was backed up on a server running version 10.00.4064. That version is incompatible with this server, which is running version 10.00.5500. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
-
Resolution
WORKAROUND:
This is a limitation within Microsoft SQL Server. Either restore the database on a server that supports the backup, update the destination to be the same version of SQL Server as the source. Or use a backup file that is compatible with this server. -
Additional Information
From Microsoft:
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/4daae3e5-15ab-4929-a122-e1bab420310e/
You cannot restore a laster version backup to a previous version. It is only forward compatible. Eventhough "R2" has SQL 2008 in it, it has a different version number and so you can not restore backup of R2 database on SQL 2008 SP1.
An alternative would be to export your database on the previous version.