Managing SQL Server Groups

You use SQL Server groups to organize sets of SQL servers. You define these server groups, and you can organize them by function, department, or any other criteria. Creating a server group is easy. You can even create subgroups within a group, and if you make a mistake, you can delete groups as well.

Introducing SQL Server Groups

In SQL Server Management Studio, you use Registered Servers view to work with server groups. To use this view or to display it if it is hidden, press Ctrl+Alt+G.

The top-level groups are already created for you, based on the SQL Server instances. Use the Registered Servers toolbar to switch between the various top-level groups. These top-level groups are organized by SQL Server instance:

  • Database ...

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.