Knowledge Base

BUG: Restore With STANDBY Option May Recover a Database

Article ID: 201760

Article Last Modified on 10/15/2002

APPLIES TO

This article was previously published under Q201760
BUG #: 52862 (SQLBUG_70)

SYMPTOMS

If you specify an empty string for the STANDBY option when you perform a RESTORE, the STANDBY option is ignored and the RESTORE statement performs a recovery of the database. Any subsequent RESTORE of transaction logs returns the following error message:
Server: Msg 4306, Level 16, State 2, 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
Backup or restore operation terminating abnormally.

WORKAROUND

Provide a valid filename and path for the STANDBY file.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The correct behavior is for "RESTORE WITH STANDBY = ''" to fail with the following error message:
Server: Msg 3170, Level 16, State 1, Line 1
The STANDBY filename is invalid.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

REFERENCES

For more information about using the STANDBY option with a RESTORE, see the RESTORE (TSQL) topic in SQL Server 7.0 Books Online.

Keywords: kbbug kbpending KB201760


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.