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
Article Type
Technical Solution


Issue



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.


Error



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.
 


Cause



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.


Solution




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

 

 


Supplemental Materials

SourceETrack
Value3288262
Description

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


Terms of use for this information are found in Legal Notices