The SQL Server instances registered under CMS are 2008R2/2012/2016.
Few boxes are stand alone SQL Servers and querying on these boxes for backup history is a bit easy.
Most of the instances are configured under Always ON (Primary/Secondary Sync/Secondary Async), and here I am facing the issue because
Some of the backups are happening on Secondary and that I need to identify manually in case of simple query run.
In case the backup happen on one node and later on, the AG failed over to other node and backup happen on that node too, I am getting the duplicate report from each node.
Here my task is to get the whole week backup history from all the SQL Server, no matter those are stand alone or part of the AG.
Create a server group(One folder up from CMS) and add all servers to group, open a query in the context of the "server group" and run your SQL query to get the history.
Create a Powershell script that iterates thru all servers, running your history query against each one in turn and collate the results into a single table.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply