Error: This backup cannot be restored using WITH STANDBY because a database upgrade is needed. (89420)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error: This backup cannot be restored using WITH STANDBY because a database upgrade is needed.
Description

Error when Log Shipping from SQL Server 2005 to SQL Server 2008 :
2012-02-05 *** Error: Could not apply log backup file '\\SecondaryServer\backups\SecondaryServer\Prouction_20090205110000.trn' to secondary database 'SecondaryDB'.(Microsoft.SqlServer.Management.LogShipping) ***
2012-02-05 *** Error: This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY.
Cause

N/A
Resolution

NOTE: This is not a LiteSpeed error.
The upgrade operation (the automatic upgrade change the version from older 611 to 655) can't be recorded in the undo file, so you can't use STANDBY if you want to restore 2005 transaction logs.
See: http://social.msdn.microsoft.com/forums/en-US/sqldisasterrecovery/thread/93398be6-0754-4104-8669-42b205700738/
Additional Information

Addl. info: http://serverfault.com/questions/145424/transaction-log-shipping-sql-server-2005-to-2008

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title