Solved

Retrieve database information

Posted on 2014-09-15
5
124 Views
Last Modified: 2014-09-22
Hi Experts,

I have a single Windows 2008 server with SQL 2008. I need to know what databases are running on this machine, and what the size of these databases are.

Is there a simple way to do this?
0
Comment
Question by:SvenIA
5 Comments
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40322813
If you have access to the SQL Server then just run the SQL Server Management Studio (should be installed in the server) and with that tool you can see the databases and their size.
0
 
LVL 32

Expert Comment

by:ste5an
ID: 40322936
No, not really.

First of all, you need to check how many instances of SQL Server are running. Then you need to connect to each instance and query sys.databases.
0
 
LVL 12

Expert Comment

by:trinitrotoluene
ID: 40323079
0
 
LVL 12

Expert Comment

by:trinitrotoluene
ID: 40323088
alternately open the sqlcommand prompt and enter

EXEC sp_databases

Open in new window


To open sqlcommand prompt, click Start->Run and enter "sqlcmd" and hit Enter
More info here
0
 
LVL 7

Author Closing Comment

by:SvenIA
ID: 40336218
Thanks!
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now