locate all databases in different servers

Question

locate all databases in different servers

stephenhai

Mr or Mrs. 500

Points: 553
More actions
April 18, 2008 at 8:47 am

#121150

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

DKlein SSCrazy Points: 2351 More actions · Answer 1

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

stephenhai Mr or Mrs. 500 Points: 553 More actions · Answer 2

Hi David,

I am looking for SQL Server DBs only on any servers if possible

Thanks

Stephen

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 3

First, locate all the SQL Servers.

Then, look at each SQL Server to see what databases are on it.

Red8Rain Hall of Fame Points: 3312 More actions · Answer 4

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] :.

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 5

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

jezemine SSCrazy Eights Points: 8059 More actions · Answer 6

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