Solved

Retrieve database information

Posted on 2014-09-15
5
134 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 48

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help Required 2 39
SQL Server - Set Field Values ito Zero Based on Related Table 4 40
PolyServe for SQL server 13 32
Negative isnull? 3 15
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

861 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