List of Databases

Question

List of Databases

Admingod

SSCertifiable

Points: 5997
More actions
November 25, 2019 at 11:57 pm

#3700809

Is there a way to get the list of databases from all sql server instances in the network? Lets say if we have 30 instances rather than getting the list from each server, instead is there a way to get the list of DB's from all 30 instances. Please advise? Thanks in advance!

Viewing 5 posts - 1 through 4 (of 4 total)

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

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

Admingod wrote:

Is there a way to get the list of databases from all sql server instances in the network? Lets say if we have 30 instances rather than getting the list from each server, instead is there a way to get the list of DB's from all 30 instances. Please advise? Thanks in advance!

you can use CMS registered server (or) if you have own CMS you can do that.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Andrey SSC Eights! Points: 840 More actions · Answer 2

https://docs.microsoft.com/en-us/sql/ssms/register-servers/execute-statements-against-multiple-servers-simultaneously

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 3

easy - register all of your servers in management studio as a group (it will appear with a pink bar at the bottom of the screen)

click on the group and run a query against the group . you can then run "select name from master.dbo.sysdatabases" - it runs against all servers

MVDBA

Steve Jones - SSC Editor SSC Guru Points: 736342 More actions · Answer 4

If you have a list of servers, you could do this in PoSh or with SQLCMD as well. The hard part is finding instances on the network, as they can be hidden.