Restore of a SQL database fails with "The backup set holds a backup of a database other than the existing database."
|Article:TECH19484|||||Created: 2009-01-03|||||Updated: 2013-04-09|||||Article URL http://www.symantec.com/docs/TECH19484|
Restore of an SQL database fails with "An error occurred on a query to database
V-79-65323-3154 An error occurred on a query to database.
SQL Server returned the following error message: The backup set holds a backup of a database other than the existing
When trying to restore an SQL Database the restore attempts fail with the above mentioned error. A close inspection of the data available for restore on the Restore Selections tab in Backup Exec may reveal an inconsistent view of what is displayed as available to be restored and what may actually be available to be restored
The catalogs folder may need to be replaced and the media re-cataloged per the following steps:
1. Close Backup Exec and stop all Backup Exec Services.
2. Open the Windows Explorer and browse to the folder where the Backup Exec Catalog Files are stored (the default location is C:\Program Files\Symantec\Backup Exec\Catalogs).
3. Rename the current catalogs folder to Old_Catalogs.
4. Create a new catalogs folder called Catalogs. Leave this new catalogs folder empty.
5. Close the Windows Explorer.
6. Start all Backup Exec Services and launch Backup Exec.
7. Run Inventory and Catalog jobs on all tapes or Backup to Disk (.BKF) Files.
8. Once all tapes have been cataloged, go to the Restore Selections tab, create a new restore job, and attempt the restore again.
The backup set holds a backup of a database other than the existing database.
Article URL http://www.symantec.com/docs/TECH19484