July 23, 2014 at 12:49 pm
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
July 23, 2014 at 2:20 pm
Are you saying you just want to shred the XML and insert the data into the tables?
July 23, 2014 at 6:40 pm
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.
July 23, 2014 at 7:04 pm
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[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply