To determine when database has been backed up the last time usually is enough to look into backup tables in msdb database. However, it doesn’t work well with Availability Groups – after the failover new active replica doesn’t know when the last FULL\DIFF backup was taken because local msdb database doesn’t have those records. It […]
- Tags but this introduces unwanted complexity. The goal is to make sure that code like this works stable even after the failover: IF dbo.lastBack, it doesn't work well with Availability Groups - after the failover new active replica doesn't know when the last FULL\DIFF backup was taken b, right after failover, To determine when database has been backed up the last time usually is enough to look into backup tables in msdb database. However, when the last data backup was taken? There is always an option to query each replicas through OPENROWSET (or anything like this)