liveBook · Manning

Server group

As explained in 100 SQL Server Mistakes and How to Avoid Them

A server group is a collection of registered SQL Server instances managed as a unit for connection and query operations.

Mistake: configuring alerts separately on every instance seems straightforward, but it requires Database Mail everywhere and creates cumbersome administration. A Central Management Server instead organizes registered instances into a server group for estate-wide queries. section 12.4.1

Checking failed backups

Register instances under a server group, then run one query each morning to find failed backup jobs. Group results include a Server column, while ROW_NUMBER() selects the latest execution for each instance. Replace the example job name with the consistent name used in your environment. section 12.4.1

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes
Explains configuration and query behavior, including per-server output and latest-result filtering, but not full inventory-database implementation.
Examples
Uses a Registered Servers configuration and a T-SQL query that retrieves the latest failed backup job from each instance.
What it assumes
Assumes familiarity with SQL Server instances and backup jobs, while showing how to create groups through Registered Servers.
What you can do after
Operate it through SQL Server Management Studio to query multiple registered instances and diagnose failed backup jobs.
How it connects
Connects server groups with Central Management Server, Registered Servers, SQL Agent jobs, Database Mail, backups, and inventory databases.
Cover of 100 SQL Server Mistakes and How to Avoid Them
liveBookmanning.com
Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Related concepts

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.