Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Manage Server Groups window helps you organize access to your SQL Server instances so you can fully leverage the scope and power of the IDERA SQL Admin Toolset tools.

A server group can contain multiple instances, whether these instances are hosted on the same computer or on different computers. When you create a server group, you specify a single set of credentials that the IDERA SQL Admin Toolset uses to connect to each instance in the group.

When you use one of the IDERA SQL Admin Toolset tools, you can specify which SQL Server instances you want to act on. Choosing a server group allows you to act on multiple instances that have a logical relationship.

...

Info

When you first launch the IDERA SQL Admin Toolset, it loads any server groups previously defined through SQL Server Management Studio (2005 and 2008) or Enterprise Manager (2000). After the initial import, you can use the Manage Server Groups tool to perform all management of the server groups.

...

You can access the Manage Server Groups window from the Tools menu on any tool window. You can also launch this window from the SQL admin toolset IDERA SQL Admin Toolset Launchpad by clicking Manage Server Groups.

...

If you select a nested server group when running one of IDERA SQL Admin Toolset tools , the tool acts on all the instances belonging to the selected server group as well as any instances belonging to the child server groups. Using our previous example, when you select the HR server group, the tool acts on the instances belonging to the Chicago, Houston, and London server groups.

 

IDERA SQL Admin Toolset delivers 24 essential administration tools. Learn more > >