Solved

Retrieve database information

Posted on 2014-09-15
5
130 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 47

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 33

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

778 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