In our last post we demonstrated how we can use registered servers to query multiple servers within a server group. This is a very useful feature of Management Studio and can simplify some administrative tasks, especially on large estates.
Registered servers can also be imported and exported to and from Management Studio making it really easy to share lists of servers, and where applicable, connection details. Anyone who has started work on a sizeable estate with lots of different SQL Servers will know what a long process it can be tracking down all the various connections.
I’m going to use the same server group as before in SSMS. By right clicking on the group and selecting tasks I can see options for Import, Export and Move To (which allows us to move objects to other groups). In this case I’m going to select Export:
Here I’m exporting my server group to a local file servers.regsrvr and I’ve also selected the option to not include user names or their passwords in the export file. After clicking OK a message is displayed informing me that the export has succeeded:
To show the import process I’ve deleted the previously created server group and will now click on the Local Server Groups, select Tasks and choose import.
We can see that the Local Server Groups doesn’t contain any groups (as I’ve just deleted it) so I’ll go ahead and click OK to recreate my previously stored servers.
For estates with multiple environment types and certainly where large numbers of instances are used the registered servers feature has a lot of benefits, particularly when not having to manually populate the names and connections of hundreds of servers!
Hey! We cover the fundamentals of maintaining SQL Server on our new DBA JumpStart course, a one day training session aimed for new DBA’s or anyone who wants to know more about SQL Server.