BUG: Restore With STANDBY Option May Recover a Database (201760)


The information in this article applies to:

  • Microsoft SQL Server 7.0
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.
Modification Type:MajorLast Reviewed:10/15/2002
Keywords:kbBug kbDSupport KB201760
©2002 Microsoft Corporation. All rights reserved.