Restore of SQL database backed up with older version of Backup Exec fails with error "The selected database appears to have been backed up from a newer version of SQL Server"
|Article:TECH209705|||||Created: 2013-08-16|||||Updated: 2014-03-13|||||Article URL http://www.symantec.com/docs/TECH209705|
The restore of a SQL database using the SQL agent for Backup Exec may fail with an error related to version when the backup was created with an older version of Backup Exec.
0xe0000346 - The selected database appears to have been backed up from a newer version of SQL Server. Backups made from newer versions of SQL Server cannot be restored to older versions of SQL Server.
SQL databases have an internal version number related to the SQL server that hosted them. Earlier Backup Exec versions could record this internal version as a 3 digit number but current versions of Backup Exec save this version number as a more basic single digit. The restore process compares this 3 digit version with the single digit target version and fails with the backup being higher in every case.
A hotfix is now available for this issue in the current version(s) of the product(s) mentioned in this article. Refer to the Hotfix link under Related Documents at the end of this article to obtain the hotfix needed to resolve the issue.
Backup Exec 2012 Rev 1798 Service Pack 4 (TECH212772).
SQL - SQL restore fails with 'database appears to have been backed up from a newer version of SQL Server'
Article URL http://www.symantec.com/docs/TECH209705