Return
-
Title
Can Log Shipping be done from a SQL 2008 Server to SQL 2008 R2 Server? -
Description
Can Log Shipping be done from a SQL 2008 Server to SQL 2008 R2 Server?
-
Resolution
Log Shipping can be done from SQL 2008 Server to SQL 2008 R2 Server only in "Restoring/Loading" mode. "Standby/Read only" mode is not possible.
You will recieve the following error if you try to restore the transaction log in standby mode:
This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY.
Same rule applies to the similar situation of Log Shipping from SQL Server 2005 to SQL Server 2008.
-
Additional Information