Solved

Retrieve database information

Posted on 2014-09-15
5
137 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 50

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 34

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

707 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