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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 20, 2015 11:17 AM
Points: 536, Visits: 2,313
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: Today @ 1:27 PM
Points: 56, Visits: 412
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


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 20, 2015 11:17 AM
Points: 536, Visits: 2,313
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 @ 5:02 PM
Points: 18,669, Visits: 16,930
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