Categories
Database Development

How to find the last data backup on secondary replica?

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 […]

Categories
Database Development

How to find the last data backup on secondary replica?

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 […]