Action
Recover the database to the latest point in time using SQL Query Analyzer:
RESTORE DATABASE database_name WITH RECOVERY
After the recovery, additional transaction logs cannot be applied.
Problem
Database restore fails with “Error has occurred while executing SQL statement”
If the database to be restored is still running, an error similar to the following may
be reported:
[Warning] From: OB2BAR@taz "(DEFAULT)" Time: 3/12/2001 7:20:28 PM
Error has occurred while executing SQL statement
Error message: 'Microsoft SQL-DMO (ODBC SQLState: 42000)
Error number: c1d
[Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access
could not be obtained because the database is in use.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE
is terminating abnormally.'
Action
To put the database offline, start SQL Server Enterprise Manager, go to the database
and click Action. Select all tasks and put them offline.
Problem
Transaction logs cannot be restored from tape
The recovery completed successfully and the database was put in norecovery state,
but transaction logs cannot be restored from tape.
Action
Recover the database to the state of ZDB to disk using the SQL Query Analyzer:
RESTORE DATABASE database name WITH RECOVERY
After the recovery, additional transaction logs cannot be applied.
Data Protector Microsoft SQL Server ZDB integration280
To Next Page
Loading...
