InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 08:06:38 GMT20http://www.sqlservercentral.com/Forums/Topic1407528-1550-1.aspxThanks, that certainly helps.Now I understand the difference, one more thing I would like to verify,there is not a way to export the central management info from 2008 to 2012, correct?ThanksTue, 22 Jan 2013 10:21:09 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1407528-1550-1.aspx[quote][b]sqlfriends (1/17/2013)[/b][hr]Thanks, that works for SQL 2008. But it seems you cannnot export that from sql 2008 to SQL 2012.Also can anyone explain what is the difference about local server groups and central management servers?from functionalities, I can do queries on multiple servers through either of them.not sure what is the difference?[/quote]When you register servers under the Local Server Groups it gets stored in: C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSvr.xml. That means the person who has registered the servers, only can use this registration and enjoy the favour of executing statements against multiple servers, not anyone else.However, things are a little different for CMS. When you register servers under Centralized Management Server details gets stored within the msdb in:dbo.sysmanagement_shared_registered_servers_internal dbo.sysmanagement_shared_server_groups_internalAs a matter of fact whoever logins to the server with the required privilege can access the registered servers & enjoy the multi server administration facility. I hope this helps!!!Regards,FaisalTue, 22 Jan 2013 09:39:17 GMTfaisalfarouqihttp://www.sqlservercentral.com/Forums/Topic1407528-1550-1.aspxThanks, that works for SQL 2008. But it seems you cannnot export that from sql 2008 to SQL 2012.Also can anyone explain what is the difference about local server groups and central management servers?from functionalities, I can do queries on multiple servers through either of them.not sure what is the difference?Thu, 17 Jan 2013 16:16:27 GMTsqlfriendshttp://www.sqlservercentral.com/Forums/Topic1407528-1550-1.aspx[url=http://technet.microsoft.com/en-us/library/ms189268(v=SQL.105).aspx]Importing and Exporting Registered Servers[/url]Wed, 16 Jan 2013 04:25:48 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic1407528-1550-1.aspxI setup a sql server instance to host central management servers.Then I added all the sql servers to diffrent group like dev, test and prod.I also server description on the propertis.Now I have a question, where is the registration stored?Is there a backup of it?If the hosting server crashes, are the registered servers info all gone?And is there also a way to move central management registered server list to another hosting server?ThanksTue, 15 Jan 2013 17:57:16 GMTsqlfriends