Post reply

backup full and trans log from 2012 to 2016 server

  • April 13, 2020 at 5:08 pm

    #3742485

    I believe I can but if I have server A (2012) and server B (2016).  I believe I can take full backup from A and restore to the B 2016, question is can I then apply a following trans log backup from A to B after full has been restored?

     

  • April 13, 2020 at 5:41 pm

    #3742499

    Short answer:  yes.

    Longer answer:  Yes, you can restore a Log backup from a lower version of SQL Server to a higher (I think you can skip up to 2 versions?) as long as you also restored the previous Full backup of the same database.

  • April 15, 2020 at 11:43 am

    #3743078

    Hi,

    you had to watch on the restore process, to put the database in the correct Recovery state:

    1. Restore FULL Backup with "RESTORE WITH NORECOVERY"
    2. Restore LOG Backup with "RESTORE WITH RECOVERY"

    Kind regards,

    Andreas

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

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