Log shipping between 2008 and 2012

  • Hi,

    I have been looking at log shipping for the first time to fulfil a warm reporting solution and would like to implement this between 2008 and to 2012 which is implied in the below article to be possible.

    http://www.sqlservercentral.com/Forums/Topic1499395-2799-1.aspx

    Having followed the above steps it 'nearly' seems to work but the log files are skippedot applied as per message below

    Skipped log backup file. Secondary DB: 'TestLS2', File: 'G:\Log Shipping\CON-POL-SAGE-01_TestLS\TestLS2_________.trn'

    Could not find a log backup file that could be applied to secondary database 'TestLS2'.

    Any ideas if this can be achieved?

    Thanks in advance

    Laurence

  • Nope, as I commented on the referenced thread, not possible.

    You can log ship up-version if and only if the logs are restored WITH NORECOVERY. You cannot have a version mismatch and restore WITH STANDBY.

    The reason you're getting the error about not being able to find a log backup is that the restore WITH RECOVERY adds extra log records, so when ther DB is backed up and re-restored WITH STANDBY, the logs from the primary no longer match and hence can't be restored.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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