Document ID: 283384
http://support.veritas.com/docs/283384 E-Mail Colleague IconE-Mail this document to a colleague

SQL Agent: Restore of Microsoft x64 SQL2005 Master database fails with the error "An error occurred on a query to database master" if the option "Automate master database restore" is selected.
Exact Error Message
An error occurred on a query to database master.

Details:
If "Automate master database restore" option was being selected, the restore job of "master" database of x64 SQL2005 might fail with the above error.

The remote agent debug log will indicate the following error:
"Exclusive access could not be obtained because the database is in use"

Workaround:

Start the SQL Server instance in Single user mode and resubmit the restore operation as given below:

1. Manually restart the SQLServer instance in Single user mode.
Example: sqlservr.exe -c -m

2. Wait for several seconds until the instance is in stable condition.

3. Modify the SQL properties of the restore job as follows:
- Deselect the option "Automate master database restore" from the Restore Job properties. (Figure 1)
Figure 1
 

- Select "Overwrite the existing database" from Tools|Options|Job Defaults|Microsoft SQL. (Figure 2)
Figure 2
 

4. Run the restore job.

Solution:

Upgrade to Backup Exec 11d or above.





Supplemental Material:

System: Ref.#Description
Error Code: 0xe0008492 Database Query Failure. See the job log for details.
ETrack: 593387 automatic master DB recovery fails for SQL2005 on x64

Products Applied:
 Backup Exec 10d (10.1), 11d (11.0) (Fixed)
Last Updated: July 20 2009 06:38 PM GMT
Expires on: 07-20-2010
Subscribe Via E-Mail IconSubscribe to receive critical updates about this document

Subjects:
 Backup Exec
   Agent For Sql: Backup-Restore, Troubleshoot

Languages:
 English (US)

Operating Systems:
Windows Server 2003

DataCenter (x64), Enterprise (x64), Standard Server(x64)