Resotring transaction Loggreenspun.com : LUSENET : SQL Server Database Administration : One Thread
I have a test database which have no backup till, now I backup the transaction log. After some updations I could not restre the transaction log ths QA gives the follwoing error please tell waht does it mean. How to find out weather there is any previous restore operation.
Server: Msg 4306, Level 16, State 1, Line 1 The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
Server: Msg 3013, Level 16, State 1, Line 1 RESTORE LOG is terminating abnormally.
-- Anonymous, June 02, 2004
The SQL Server Books Online offers the following advice on the topic of "Error 4306":
After the database has been recovered, no further restore operations may be performed.
To recover a database, start the sequence over and use the NORECOVERY clause on all RESTORE statements except the last. If you are maintaining a standby server and want to bring up the database in read-only mode between restore operations, use the STANDBY clause of RESTORE instead of the NORECOVERY clause.
Hope this helps,
-- Anonymous, June 07, 2004