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


Subject

Issue



Restore of an SQL database fails with  "An error occurred on a query to database " and "The backup set holds a backup of a database other than the existing database."


Error



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

 


Solution



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.

 


Supplemental Materials

SourceUMI
ValueV-79-65323-3154
Description

The backup set holds a backup of a database other than the existing database.

 



Legacy ID



246360


Article URL http://www.symantec.com/docs/TECH19484


Terms of use for this information are found in Legal Notices