April 18, 2008 at 8:47 am
Currently, there are databases that are resided on different servers. Some of them I know where they are, but some of them I have no idea (lack of documentation)
Is there any way or tool to locate all the databases in different servers?
Thanks
April 18, 2008 at 9:34 am
Are you looking for SQL Server DBs or any DBs, and by "servers" are you including non-database servers in your search, i.e... File servers?
David
April 18, 2008 at 12:07 pm
Hi David,
I am looking for SQL Server DBs only on any servers if possible
Thanks
Stephen
April 18, 2008 at 12:10 pm
First, locate all the SQL Servers.
Then, look at each SQL Server to see what databases are on it.
April 18, 2008 at 1:26 pm
1) locate all SQL servers which is easy to do by running 'osql -L' at the command prompt and pipping it to a text file
2) bcp that txt file into a table inside a database
3) add all the servers as linked servers, can be done via a while loop
4) run select * from [servername]...sys.databases, can be done via a while loop.
done.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
April 18, 2008 at 6:09 pm
Michael Valentine Jones (4/18/2008)
First, locate all the SQL Servers.Then, look at each SQL Server to see what databases are on it.
Heh... having one of "those" days, Michael? 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
April 18, 2008 at 11:35 pm
Michael Valentine Jones (4/18/2008)
First, locate all the SQL Servers.Then, look at each SQL Server to see what databases are on it.
reverse the steps for bonus points.
---------------------------------------
elsasoft.org
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply