Post reply

Restore logs from SQL2005 db to SQL2012 db?

  • December 1, 2014 at 7:33 am

    #292977

    Hi!

    I have a large(ish) database on SQL Server 2005 that I need to move to a new server running SQL Server 2012.

    what I would like to do is move a full backup to the new server & restore with no recovery, then keep it in sync with the old database using transaction logs until I'm ready to cutover

    Will the transaction log restores work on SQL 2012 if they come from a SQL 2005 database?

    Thanks

  • December 1, 2014 at 7:42 am

    #1761713

    If the initial database restore succeeded, they should.

    You have done all necessary upgrade testing?

    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

  • December 1, 2014 at 7:48 am

    #1761717

    thanks - we're nowhere near this happening yet, just had some questions about 'can this be moved in x amount of time?'

    It will be tested 😀

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

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