Senior DBA Class - Transaction Log Shipping Tips and Tricks

Sdílet
Vložit
  • čas přidán 15. 03. 2021
  • In theory, log shipping is easy: just restore your transaction log backups. In reality, you need to understand how to deal with unplanned failovers, reversing log shipping the other direction, and fixing a lagging secondary.

Komentáře • 8

  • @sxygeekdn
    @sxygeekdn Před 3 lety +3

    Microsoft gave us some more entitlement in the SQL Server 2019 Licensing guide.

  • @sachinkhari5058
    @sachinkhari5058 Před 3 lety

    Thank you for upload

  • @Paramonos01
    @Paramonos01 Před rokem

    Standby mode does not support log shipping with different SQL versions, only NORECOVERY mode does.

  • @ced4298
    @ced4298 Před rokem

    @brent can you share the link to the white paper that demonstrates the google cloud process that you referenced?

  • @shankarkulkarni9615
    @shankarkulkarni9615 Před 3 lety

    thanks you

  • @kiuandziu9550
    @kiuandziu9550 Před rokem

    Why is log shipping recommended then over Full back up and restore approach?