-
Title
Error: "The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY" -
Description
Steps to duplicate:
Create LiteSpeed transaction log backup to local or network drive. Restore via GUI or by script, selecting a non-existent device. The return message indicates that the @with = N'STANDBY or @with = N'NORECOVERY' parameter is missing, which is wrong. It should indicate that the @filename = parameter is the problem.
In the examples below the backup file is located on the C: drive.
exec master.dbo.xp_restore_log @database = N'Northwind',
@filename = N'D:\Backup\2000\Northwind200805090856LiteSpeed_Trans.BKP',
@filenumber = 1,
@with = N'STANDBY = N''undo''',
@with = N'NOUNLOAD',
@with = N'STATS = 10',
@with = N'MOVE N''Northwind_log'' TO N''D:\Program Files\Microsoft SQL Server\MSSQL\Data\Northwind2_Log.ldf'''
***********************
exec master.dbo.xp_restore_log
@database = N'Northwind',
@filename = N'D:\Backup\2000\Northwind200805090856LiteSpeed_Trans.BKP',
@filenumber = 1,
@with = N'NORECOVERY',
@with = N'NOUNLOAD',
@with = N'STATS = 10',
@with = N'MOVE N''Northwind_log'' TO N''D:\Program Files\Microsoft SQL Server\MSSQL\Data\Northwind2_Log.ldf'''
***********************
Both return the same message.
Server: Msg 62309, Level 19, State 1, Line 0
SQL Server has returned a failure message to LiteSpeed which has prevented the operation from succeeding.
The following message is not a LiteSpeed message. Please refer to SQL Server books online or Microsoft technical support for a solution:
RESTORE LOG is terminating abnormally.
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. -
Cause
Product defect
-
Resolution
Fixed in Version 5.0.1.1060 of LiteSpeed.
-
Defect ID
CR49449 -
Additional Information
The message should read:
LiteSpeed Version 4.8.4.00086
Copyright (C) 2004-2006, Quest Software Inc. All Rights Reserved.
Quest Software.
Registered Name: Your Company Name Here
Server: Msg 50021, Level 19, State 1, Line 0
The device is not ready.
LiteSpeed could not open the Backup file: (E:\Backup\2000\Northwind200805090938LiteSpeed_Full.BKP).
The previous system message is the reason for the failure.
-OR-
Something similar to the GUI Destination Disk window - "Unable to verify the existence of the backup location. Do you want to use the backup location anyway?"