Log shipping from sql 2008 to 2016?

  • Siten0308

    SSCarpal Tunnel

    Points: 4031

    Hello,

    We want to do a migration, these databases range from 100-500 gigs of data, and want to log ship from sql 2008 to sql 2016 enterprise, we tried already to setup with error saying something like need to put it standby without recovery etc., so wondering what solution did anyone or option did they get it to work with log shipping or a log shipping work around or alternative solution did anyone come up with if they faced a situation similar to mine?

    thanks in advance

  • Perry Whittle

    SSC Guru

    Points: 233794

    how were you setting up the log shipping session, were you trying to use standby mode?
    To log ship between versions of sql you must leave the secondary database in restore mode.
    The Secondary must also be the higher version of sql server

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

  • Siten0308

    SSCarpal Tunnel

    Points: 4031

    Hey SSChampion, thanks for the response, ya 2008 is the primary and the 2014 is the secondary, so leave it as restore mode... with recovery, no recovery? I tried it with stand by and thats when it gave me the error message.

  • Perry Whittle

    SSC Guru

    Points: 233794

    has to be restore mode which is with no recovery.

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

  • Siten0308

    SSCarpal Tunnel

    Points: 4031

    Gotya thanks, I will try that out, thanks again 🙂

  • Siten0308

    SSCarpal Tunnel

    Points: 4031

    Ok so to make things easier, and we tested, and worked beautifully, we went with mirroring, with this solution which is similar to log shipping, so big thanks SSChampion for your help 🙂

  • Gail Shaw

    SSC Guru

    Points: 1004446

    Siten0308 - Thursday, February 16, 2017 1:44 PM

     big thanks SSChampion for your help 🙂

    btw, the person who helped you is Perry.
    Champion is just the forum ranking.

    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
  • Perry Whittle

    SSC Guru

    Points: 233794

    Mirroring and log shipping are not the same they work very differently

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

  • This was removed by the editor as SPAM

  • Kevin3NF

    SSCarpal Tunnel

    Points: 4672

    Adding on a little...mirroring sends mistakes and "oops" moments to the mirror very quickly.   With LS, you have by default 15-45 minutes (jobs are set to 15 each) to keep the oops from restoring 🙂

    Different techniques for different goals 🙂

    ------------------------------------------------------------------------------------------------
    Standing in the gap between Consultant and Contractor
    Kevin3NF
    DallasDBAs.com/Blog
    Why is my SQL Log File HUGE?!?![/url]
    The future of the DBA role...[/url]
    SQL Security Model in Plain English[/url]

  • alexwjohn

    Newbie

    Points: 7

    In order to get SQL Mirroring working with asynchronous mode, do you have SQL Server 2008 and 2016 Enterprise edition?

    Or can this work with between 2008 Standard edition and 2016 Datacenter edition?

    I have SQL Server 2008 Standard Edition (primary) and SQL Server 2016 DataCenter Edition (secondary).

  • Kevin3NF

    SSCarpal Tunnel

    Points: 4672

    Database mirroring Principal and Mirror have to be the same version

    ------------------------------------------------------------------------------------------------
    Standing in the gap between Consultant and Contractor
    Kevin3NF
    DallasDBAs.com/Blog
    Why is my SQL Log File HUGE?!?![/url]
    The future of the DBA role...[/url]
    SQL Security Model in Plain English[/url]

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

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