Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

SQL Restore Failure

Updated: 22 May 2010 | 3 comments
Abdallah Alsaleh's picture
0 0 Votes
Login to vote
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.
 
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.

Comments

thegoolsby's picture
04
Jun
2007
0 Votes 0
Login to vote

Hello,

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


Abdallah Alsaleh's picture
05
Jun
2007
0 Votes 0
Login to vote

Thanks Collin;
I stopped the related processes and services. The restore job ran successfully.
txtech1997's picture
28
Jun
2007
0 Votes 0
Login to vote

I'm working on a restore of a SQL db that is about 100gb.  I have setup the SQL redirection to the only server we have that has enough space for it.  It has been sitting at 97% completed for over 2 hours.  The server is a Windows 2003 server and Backup Exec is 10d.  I can see that the db is in the restore dierctory, but it will not end or give alerts to any kind of issue.
 
Any help is greatly apprciated.
 
Charles