Return
-
Title
LOG Restore WITH STANDBY Fails -
Description
The backup was from SQL 2000. The restore is on SQL 2005. If the database backup is set with the STANDBY option, the backup will fail with the following error:
"Msg 62309, Level 19, State 1, Line 1
SQL Server has returned a failure message to LiteSpeed 2005 which has prevented the operation from succeeding.
The following message is not a LiteSpeed 2005 message. Please refer to SQL Server books online or Microsoft technical support for a solution:
RESTORE LOG is terminating abnormally.
This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY."
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.