How to list all SharePoint databases

[neualex]

Hi guys,
Does anyone know how to list all SP databases programmatically (.net) as the Central Administration / Operations / Perform Backup page does?

Hope you can help!
Thanks,
...Alex

 

[SPV]

Don't know about .net, but the stsadm command can do this on a per-URL basis:

[tt]stsadm -o enumcontentdbs -url <url>[/tt]

I hope this helps.

 

[SPV]

After posting that reply, I found myself wondering how you would programatically get all the URLs (given that you need to run [tt]stsadm -o enumcontentdbs[/tt] for each URL)...

[tt]stsadm -o enumzoneurls[/tt] might help. It does list all the web applications, but it also shows the alternate URLs too so you'd need to filter the output, perhaps just looking for the Default URLs.

Anyway, I'm probably heading off on a tangent here as you didn't actually ask that question... ;-)

 

[neualex]

Thanks!
I ended up in the Central Administration page since I didn't find a way to list all databases.

You can programatically list all web apps, site collections, subsites, if you need the code, just let me know.

...Alex

 

[RobertKaucher]

Alex, if it's not too much code, why not post it. I would like to see it.

 

[neualex]

SPWebServiceCollection webServices = new SPWebServiceCollection(SPFarm.Local);

foreach (SPWebService webService in webServices)
foreach (SPWebApplication webApplication in webService.WebApplications)
foreach (SPSite siteCollection in webApplication.Sites)