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: 2013-08-16|||||Article URL http://www.symantec.com/docs/TECH209705|
|NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.|
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.
Workaround - Install an earlier version of Backup Exec, such as 2010 R2 in trial mode and perform the restore.
Symantec Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned in this article. Symantec Corporation is committed to product quality and satisfied customers.
This issue is currently under investigation by Symantec Corporation. Pending the outcome of the investigation, this issue may be resolved by way of a patch or hotfix in current or future revisions of the software. However, this particular issue is not currently scheduled for any release. If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns. For information on how to contact Symantec Sales, please see http://www.symantec.com Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.
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