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."
This error message is common when attempting to restore a SQL 2000 backup to SQL 2005 with standby.
Microsoft SQL Server 2005 will only allow SQL Server 2000 databases to be restored with recovery or left in read only mode. Restoring with the STANDBY option is not allowed.
For additional information on this topic: http://support.microsoft.com/kb/314546/en-us
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy