Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Thursday, May 19, 2016 7:58 AM
Points: 540, Visits: 2,422
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: Friday, December 18, 2015 10:13 AM
Points: 56, Visits: 424
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: Thursday, May 19, 2016 7:58 AM
Points: 540, Visits: 2,422
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: 2 days ago @ 1:58 PM
Points: 19,801, Visits: 18,073
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