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 2000 Forums
 SQL Server Administration (2000)
 How to find the size of DB?

Author  Topic 

sunnyjassal
Starting Member

28 Posts

Posted - 2004-10-06 : 16:33:12
I have 4 databases on SQL Server. I would like to find out how much space is each taking on the machine. How can I find out?

Basically how can I find out the size of each DB?

Also once the size is known. Does that size include the size of mdf files and ldf for that db? or is that seperate?

Thanks,

Sunny

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-06 : 16:35:18
sp_spaceused

Tara
Go to Top of Page

sunnyjassal
Starting Member

28 Posts

Posted - 2004-10-06 : 17:04:14
Thanks. That worked!
Go to Top of Page
   

- Advertisement -