Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Redbuild CMS tables from XML file Expand / Collapse
Author
Message
Posted Wednesday, July 23, 2014 12:49 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:13 AM
Points: 467, Visits: 1,883
Hello,

I had to reinstall my local copy of SQL a few weeks ago, which naturally overwrote the msdb.dbo.sysmanagement_shared_server_groups_internal and msdb.dbo.sysmanagement_shared_registered_servers_internal tables. However I still have the local XML file that SSMS reads so I can still access the groups, I just get weird errors when trying to re-register my install as the new CMS. Has anyone ever rebuilt those tables from the XML file or know of a way to repopulate?

Thanks

Post #1595666
Posted Wednesday, July 23, 2014 2:20 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:49 PM
Points: 56, Visits: 394
Are you saying you just want to shred the XML and insert the data into the tables?
Post #1595708
Posted Wednesday, July 23, 2014 6:40 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:13 AM
Points: 467, Visits: 1,883
Sort of, with the end result being rebuilt CMS tables. I guess I'm not sure what from the XML file is supposed to end up where.
Post #1595771
Posted Wednesday, July 23, 2014 7:04 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:53 AM
Points: 17,812, Visits: 15,738
Can you post the error messages?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1595772
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse