How can we export and import registered servers using SSMS?


In our organization we have number of SQL Server instances which are grouped by their Business Unit, Environment (PRD, DEV etc). For new joiners, it is hard to find out the list servers in absence of CMDB. As a solution, you can ask your team member to give you the list of registered servers by doing using server import/export option.

1. In Registered Servers, right-click a server group, and then click Export.See below image for more information.

2.In the Export Registered Servers dialog box, from the Server Group list select the location where you would like to save the registered server information, in the Export file box type a name for the exported file, and then click Save.

SQL Server will create the file with .RegSvr extension which stores server info in XML format.

In Registered Servers, right-click a server group, and then click Import and select the export file with .RegSvr extension. See below image for more information.

Advertisements

One thought on “How can we export and import registered servers using SSMS?

  1. Jim

    The path to the file is … C:\Users\ReplaceWithUserName\AppData\Roaming\Microsoft\Microsoft SQL Server\110\Tools\Shell

    Reply

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s