Database restore fails with exclusive access error

Technote (troubleshooting)


Problem(Abstract)

Performing a SQL Database Restore with the Data Protection for MS SQL results in an exclusive access error, and restore failure.

Symptom

ACO5436E A failure occurred on stripe number (0), rc = 428

ACO5407E The SQL server aborted the operation.
Restore of DATABASE failed.
An exception occurred while executing a Transact-SQL statement or batch.
Exclusive access could not be obtained because the database is in use.

Cause

Another process is accessing the database, or the database is not in a state to be overwritten.

Resolving the problem

The Microsoft SQL Server prevents restores from overwriting databases that are in use. To avoid this error it is critical that the database is not being accessed. You can do this by making sure the database is not in a "mounted" state when the restore starts.


Also, the database in use error may be caused by having an open session with the MS SQL Enterprise Manager since it is connected to and accessing the SQL Server. Note that this message can be received even if the MS SQL Enterprise Manager if not actively accessing the database for which the restore is being attempted. It is suggested to close the MS SQL Enterprise Manager window before performing the restore.


Product Alias/Synonym

DP

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager for Databases
Data Protection for MS SQL

Software version:

All Versions

Operating system(s):

Windows

Reference #:

1607660

Modified date:

2012-09-05

Translate my page

Machine Translation

Content navigation