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 |
Problem
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.
|
|
| Source | Error Code |
| Value | 0xe0008492 |
| Description | Database Query Failure |
| Source | UMI |
| Value | V-79-65323-3101 |
| Description | Exclusive access could not be obtained because the database is in use |
Related Articles
Legacy ID
240054
Article URL http://www.symantec.com/docs/TECH16063
Terms of use for this information are found in Legal Notices
Thank you.