SQLTeam.com | Weblogs | Forums

Alwayson backup check


#1

Is there is a way to check the SQL server database backups configured on Always on. Currently i have to check on all replicas to check the status of the database backup since some dbs are configured to backup on secondary node. Is there is any simple way/script to check the last backup status from only one replica/Server? It would be great helpful if some one can answer with some scripts. Thanks in advance.


#2

I struggled with this when I was writing Is It SQL.. I ended up having to query each replica's backup history and pull it all together. PowerShell should be able to pull that all together into a central server. Or maybe use linked servers to centralize it. Once you get it all on one server it's much easier. Sorry, I don't have any scripts to offer.