Database restore fails with exclusive access error
Performing a SQL Database Restore with the Data Protection for MS SQL results in an exclusive access error, and restore failure.
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.
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.
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: 2014-07-14