Post reply

Log Shipping between SQL Server 2005 and 2008

  • March 11, 2010 at 9:55 am

    #156771

    Hi,

    I would like to implement log shipping between our OLTP database which is SQL Server 2005 and a reporting database which is SQL Server 2008. Is this possible? I have setup log-shipping, but when it tries to restore the log file to the secondary SQL 2008 server, if fails with ***Error: This backup cannot be restored using WITH STANDBY because a database upgrade is needed.

    Any help appreciated.

    Regards,

    Jo

  • March 11, 2010 at 10:22 am

    #1132180

    conor.devlin (3/11/2010)

    Hi,

    I would like to implement log shipping between our OLTP database which is SQL Server 2005 and a reporting database which is SQL Server 2008. Is this possible? I have setup log-shipping, but when it tries to restore the log file to the secondary SQL 2008 server, if fails with ***Error: This backup cannot be restored using WITH STANDBY because a database upgrade is needed.

    Any help appreciated.

    Regards,

    Jo

    Yes this possible, check this out.

    http://www.sqlservercentral.com/Forums/Topic281187-146-1.aspx

    EnjoY!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply