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)
 Database Size

Author  Topic 

poser
Posting Yak Master

124 Posts

Posted - 2008-01-15 : 11:30:08
I have a huge database that is 105 gig and growing daily. What is the max size MicroSoft recommends? Or what is your thoughts on this?
When does it become unmanageable?
I ask because users frequently delete stuff and then we have to find space to restore.
Thanks for any and all input.
R/P

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-15 : 23:42:57
Depends on server's disk capacity and horsepower. And 105gb is not big db, we have a 4tb db.
Go to Top of Page

Westley
Posting Yak Master

229 Posts

Posted - 2008-01-17 : 06:03:59
you might like to think about breaking them into multiple data files, it will be easier to maintain.
Go to Top of Page
   

- Advertisement -