July 15, 2003 at 2:44 pm
I manage over 500 databases on 60 servers. Does anybody know how to find out quickly which server a certain database is hosted on?
Thanks in advance.
July 15, 2003 at 2:59 pm
you'd have to have a central rollup of the databases. I have some scripts that will scan a list of servers, but if you don't have a list, you'd have to generate one.
SQLDMO can help you here. Use the ListAvailableServers method to get a collection of servers and you could loop through that and check the Databases collection of each.
Steve Jones
July 15, 2003 at 3:08 pm
If you're going to do it very often you'd want to run it as job and save the results, it'll be slow connecting to x servers until you find the one you need.
Andy
July 15, 2003 at 4:01 pm
Thank you very much for the input. I have no problem building a table with a list of servers. Could you give me a script to loop through all servers?
Thanks again for your help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply