Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


central management servers


central management servers

Author
Message
sqlfriends
sqlfriends
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2041 Visits: 3853
I 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?

Thanks
Joie Andrew
Joie Andrew
SSC Eights!
SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)SSC Eights! (968 reputation)

Group: General Forum Members
Points: 968 Visits: 1899
Importing and Exporting Registered Servers

Joie Andrew
"Since 1982"
sqlfriends
sqlfriends
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2041 Visits: 3853
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?
ffarouqi
ffarouqi
SSC Veteran
SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)SSC Veteran (297 reputation)

Group: General Forum Members
Points: 297 Visits: 1240
sqlfriends (1/17/2013)
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?


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_internal

As 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,
Faisal
sqlfriends
sqlfriends
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2041 Visits: 3853
Thanks, 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?

Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search