Using a Tail Log Backup in a SQL Server Migration (Dear SQL DBA Episode 34)
Vložit
- čas přidán 25. 07. 2024
- When you migrate a database, it can be useful to prove that you moved all the data and didn't miss any transactions. Learn how to use a tail log backup in a migration scenario.
For clickable links from this episode, see the post here: www.littlekendra.com/2017/03/... - Věda a technologie
Got to know another use case scenario for tail log backup - I've seen almost all episodes and learnt something new from each !! This is a fabulous web series for SQL DBAs - Appreciate it !!
Great vid. Worth mentioning that mirroring isn't an option if you're also upgrading the version of SQL Server (unless anyone knows a nice trick around this?). Log Shipping is slightly more problematic too.
Thanks Kendra. Always happy to be corrected. I was pretty sure we were getting version errors but I'll double check, and review the MS documentation on rolling upgrades. Thanks!!
I finally tracked down why I thought it wasn't possible to log ship to a later version. As Kendra pointed out, it is possible, however you can't recover the DB in standby mode. This of course means that you can't query it.
Brent Ozar mentions it in an article here www.brentozar.com/archive/2015/01/reporting-log-shipping-secondary-standby-mode/.
Credit where credit's due Kendra :)