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 determine when to buy additional hard drive

Author  Topic 

pras2007
Posting Yak Master

216 Posts

Posted - 2008-03-21 : 07:19:55
Hello All,

is there a way to find out how big my db is? Furthermore, how can I find out how much data is being stored in the db on a daily basis? What I'm trying to find out is when I would need to buy more hard drives. pleas advise. Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-03-21 : 13:53:59
Check out sp_spaceused and sp_databases.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-21 : 17:12:30
Also check free space left on disks.
Go to Top of Page
   

- Advertisement -