SQL Agent: "Exclusive access could not be obtained because the database is in use" when performing a Microsoft SQL 2000 or SQL 2005 restore operation

Article:TECH16063  |  Created: 2010-01-20  |  Updated: 2012-01-12  |  Article URL http://www.symantec.com/docs/TECH16063
Article Type
Technical Solution

Product(s)

Subject

Issue



SQL Agent: "Exclusive access could not be obtained because the database is in use" when performing a Microsoft SQL 2000 or SQL 2005 restore operation


Error




An error occurred on a query to database TEST.
Exclusive access could not be obtained because the database is in use.


Cause



This error is caused by the destination SQL database being in read-only mode 


 


Solution



 

To resolve this, perform the following steps:

 
1.  Open SQL Server Enterprise Manager
 
2.  Highlight and right-click on the destination database (Figure 1)
 

 
Figure 1
 
 
 

 
3.  Select Properties
 
4.  Select the Options tab
 
5.  Clear the Read-only check box (Figure 2)
 

 
Figure 2
 
 
 

 
6. Click OK
 

 
The restore can be run again and should be successful.

 

Supplemental Materials

SourceError Code
Value0xe0008492
Description

Database Query Failure


SourceUMI
ValueV-79-65323-3101
Description

Exclusive access could not be obtained because the database is in use



Legacy ID



240054


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


Terms of use for this information are found in Legal Notices