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: Today @ 6:04 AM
Points: 488, Visits: 1,993
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: Monday, November 3, 2014 2:21 PM
Points: 56, Visits: 402
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: Today @ 6:04 AM
Points: 488, Visits: 1,993
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 @ 9:16 AM
Points: 17,966, Visits: 15,971
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