Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 143
  • Last Modified:

Retrieve database information

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
SvenIA
Asked:
SvenIA
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
ste5anSenior DeveloperCommented:
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
 
trinitrotolueneDirector - Software EngineeringCommented:
0
 
trinitrotolueneDirector - Software EngineeringCommented:
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
 
SvenIAAuthor Commented:
Thanks!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now