Microsoft KB Archive/201760

= BUG: Restore With STANDBY Option May Recover a Database =

Article ID: 201760

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.