Can Log Shipping be done from a SQL 2008 Server to SQL 2008 R2 Server?
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.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center