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
Thanks, buddy. This was very helpful!
Glad to hear it!
@brent can you share the link to the white paper that demonstrates the google cloud process that you referenced?
Standby mode does not support log shipping with different SQL versions, only NORECOVERY mode does.
Why is log shipping recommended then over Full back up and restore approach?
Because full backups & restores take a long time.
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
Thank you for upload
thanks you