May 4, 2011 at 7:39 am
I was given an xml document to use to import a list of servers. The list contains a moderate amount of servers. In the past I've only had to deal with a few servers at a time so importing/exporting list was somewhat irrelevant. Is this something exclusive to CMS? thanks!
May 4, 2011 at 7:42 am
CMS?
May 4, 2011 at 7:45 am
Ninja's_RGR'us (5/4/2011)
CMS?
Sorry, a central management server
May 4, 2011 at 8:01 am
Ok, but I still don't really see the question and how I can guide you.
So you got a list of servers. You need to manage them. then what? what's the problem?
May 4, 2011 at 8:10 am
Have a gander at this article.
It should be just the same as if importing just a few servers.
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
May 4, 2011 at 8:12 am
Sorry, How to actually import this list of servers from an xml schema file. All servers I've managed in the past I've manually set up in SSMS. I don't see any option to import this file so I'm wondering if either I'm missing something or if this is something only possible with a central management server. Thanks again.
May 4, 2011 at 8:15 am
Is it a .xml extension or a .regsrvr extension? SSMS exports servers and imports server lists via the regsrvr extension. The file contains xml info and is very straightforward to import.
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
May 4, 2011 at 8:17 am
I actually figured this out. Under the registered server, right clicking the Local Server Groups and selecting the import task got me there. Thanks again!
May 4, 2011 at 8:19 am
SQLRNNR (5/4/2011)
Is it a .xml extension or a .regsrvr extension? SSMS exports servers and imports server lists via the regsrvr extension. The file contains xml info and is very straightforward to import.
Yes this was it, sorry for not being descriptive enough! Thanks again!
May 4, 2011 at 8:21 am
Good to hear
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
May 4, 2011 at 8:24 am
Happy to <almost> help :w00t:.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply