SQL Restore Failure
Updated: 22 May 2010 | 3 comments
Hi,
I have backed up SQL 2000 successfully. The backup selection included the following databases Altiris, Altiris_Incedents, eXpress, Laserfiche, maseter, model, msdb, Northwind, pubs and seeddb2.
when i try to restore the SQL database, I get the following error:
Restore- ALTIRIS V-79-57344-33938 -
An error occurred on a query to database Altiris.
V-79-57344-33938 - Exclusive access could not be obtained because the database is in use.
V-79-57344-33938 -
An error occurred on a query to database Altiris_Incidents.
V-79-57344-33938 - Exclusive access could not be obtained because the database is in use.
V-79-57344-33938 -
An error occurred on a query to database master.
V-79-57344-33938 - RESTORE DATABASE must be used in single user mode when trying to restore the master database.
An error occurred on a query to database Altiris.
V-79-57344-33938 - Exclusive access could not be obtained because the database is in use.
V-79-57344-33938 -
An error occurred on a query to database Altiris_Incidents.
V-79-57344-33938 - Exclusive access could not be obtained because the database is in use.
V-79-57344-33938 -
An error occurred on a query to database master.
V-79-57344-33938 - RESTORE DATABASE must be used in single user mode when trying to restore the master database.
The rest of databases are restored successfully.
The Backup Exec version is 11d Rev. 7170 with the latest hotfixes.
I can restore the master database only if I check it alone with no other database and choose the Automate Master Database Restore but there is no way to restore the other failed databases (Altiris, Altiris_Incedents).
Any help would be appreciated.
discussion Filed Under:
Comments
The error is occurring because there is an application or process which has a lock on the databases in question. SQL is preventing the restore from being performed as SQL cannot gain total access on the databases. You should see errors from SQL in the application log on your SQL server.
Determine what application or process is accessing the database and stop the process from running when you attempt the restore.
Collin Goolsby
Technical Support Engineer
Symantec Corporation
www.symantec.com
Would you like to reply?
Login or Register to post your comment.