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

Answers

Kalyan,

The SQL Server Books Online offers the following advice on the topic of "Error 4306":

Explanation

After the database has been recovered, no further restore operations may be performed.

Action

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,

Eric

-- Anonymous, June 07, 2004