How to find out the size of my database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

How to find out the size of my database

Author

Topic

pras2007
Posting Yak Master

216 Posts

Posted - 2009-07-30 : 00:14:20

Hello All,

Does anybody know if there is a sys sp or view, that can provide the following information about my database:

-Server Name
-DB Name
-Data File Size (MB)
-Log File Size (MB)
-Total Table Count
-Total Record Count

Please advice. Thanks.

wshawnmelton
Starting Member

17 Posts

Posted - 2009-07-30 : 14:50:35

There are individual views that can provide some or most of that information, not one that gets it all in one fail swoop.

w s melton

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-07-30 : 14:56:13

look through sql's meta data functions on Books Online:

http://technet.microsoft.com/en-us/library/ms187812(SQL.90).aspx

Be One with the Optimizer
TG

EDIT:
and serverproperty() is listed under "system functions"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources