locked
Log Shipping between SQL Server 2005 and SQL Server 2008 RRS feed

  • Question

  • Is it possible to configure Log Shipping between SQL Server 2005 and SQL Server 2008?  That is the originating database and server (the primary database) is SQL Server 2005, and the receiving database and server (the secondary database) is SQL Server 2008.

    Monday, July 12, 2010 4:50 PM

Answers

  • Hi SQLScript,

     

    Is it possible to configure Log Shipping between SQL Server 2005 and SQL Server 2008?

    If the primary database is in the instance of SQL Server 2005 and the secondary database is in the instance of SQL Server 2008, it is possible.

    Meanwhile log shipping from SQL Server 2008 to SQL Server 2005 is not possible.

     

    This is because that log shipping is implemented via backing up and restoring database and transaction log from primary database to secondary database. Since the backup of database and transaction log could be restored from previous version of SQL Server to later version of SQL Server, it is possible to implement log shipping from SQL Server 2005 to SQL Server 2008. Meanwhile it is possible to restore backup of database and transaction log from later version to previous version of SQL Server, the log shipping from SQL Server 2008 to SQL Server 2005 is impossible.

     

    If anything is unclear, please let me know.

    • Proposed as answer by Janos BerkeMVP Wednesday, July 14, 2010 10:00 AM
    • Marked as answer by Tom Li - MSFT Sunday, July 18, 2010 1:20 PM
    • Unmarked as answer by Tom Li - MSFT Friday, August 6, 2010 1:09 AM
    • Marked as answer by Tom Li - MSFT Friday, August 6, 2010 1:26 AM
    Wednesday, July 14, 2010 9:30 AM

All replies

  • Log shipping is not an option in that environment, but you can use replication

    Monday, July 12, 2010 5:24 PM
  • Hi SQLScript,

     

    Is it possible to configure Log Shipping between SQL Server 2005 and SQL Server 2008?

    If the primary database is in the instance of SQL Server 2005 and the secondary database is in the instance of SQL Server 2008, it is possible.

    Meanwhile log shipping from SQL Server 2008 to SQL Server 2005 is not possible.

     

    This is because that log shipping is implemented via backing up and restoring database and transaction log from primary database to secondary database. Since the backup of database and transaction log could be restored from previous version of SQL Server to later version of SQL Server, it is possible to implement log shipping from SQL Server 2005 to SQL Server 2008. Meanwhile it is possible to restore backup of database and transaction log from later version to previous version of SQL Server, the log shipping from SQL Server 2008 to SQL Server 2005 is impossible.

     

    If anything is unclear, please let me know.

    • Proposed as answer by Janos BerkeMVP Wednesday, July 14, 2010 10:00 AM
    • Marked as answer by Tom Li - MSFT Sunday, July 18, 2010 1:20 PM
    • Unmarked as answer by Tom Li - MSFT Friday, August 6, 2010 1:09 AM
    • Marked as answer by Tom Li - MSFT Friday, August 6, 2010 1:26 AM
    Wednesday, July 14, 2010 9:30 AM
  • I have been trying this in a test environment and it has been failing.

    Primary server is SQL 2005, Backup server is SQL 2008 R2

    Originally both servers were SQL2005 and I upgraded the backup to SQL2008 R2. The log-shipping failed.

    I have tried re-creating the log-shipping and putting the monitor server on SQL2005 and not on 2008 where it was. It didn't make a difference

    The restore job fails, with the following error:

    *** Error: This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY.

    Tom Li, wrote that it is possible. A more specific question, is it possible to CREATE log shipping from SQL 2005 to SQL 2008 R2, not by upgrading the backup server?

     

    Thursday, August 5, 2010 2:29 PM
  • Hi YitzchakW123,

     

    Thanks for your post.

    I recommend that you ask it in a new thread and you may get better and quicker support.

    Friday, August 6, 2010 1:27 AM
  • Hi YitzchakW123,

    Please not that you cant logshipping from SQL server older to new version using logshipping wizard. But you can configure using manual or custom logshipping. Older version to newer version has limitation. You cant configure STANDBY mode (read only) logshipping. Recovery model logshipping
    is only possible.


    Ramesh S
    www.sequalserver.com
    Friday, August 6, 2010 4:59 AM