Senior DBA Class - Transaction Log Shipping Tips and Tricks

[@jimmynashville3494]

Thanks, buddy. This was very helpful!

[@BrentOzarUnlimited]

Glad to hear it!

[@ced4298]

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

[@Paramonos01]

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

[@KianshGameverse]

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

[@TheBrentOzar]

Because full backups & restores take a long time.

[@Patmorgan235Us]

If you use log shipping you're constantly restoring to the secondary. So your only ever a few minutes behind. all you have to do is wait for the last transaction log back up to apply and your done. if you do full backs/restore you have to wait for the entire back up to transfer and be pulled into SQL Server

[@sachinkhari5058]

Thank you for upload

[@shankarkulkarni9615]

thanks you