Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using SQlserver2005. My database are becomeing very large and space is becoming very sparse.

Please suggest what to do? (apart from buying space)

share|improve this question
  • Or you have DB recovery model = FULL and not backing up the transaction log
  • or you have very long-running huge transactions
  • or you perform massive inserts-deletes with GHOST CLEANUP process switched down
  • or it is all ok and it is your natural load and data grow behavior
share|improve this answer
last one it is all ok i mean all the above are ok and it is natural load and data grow behaviuor then? – angel94 Jan 18 '12 at 8:57
just add a new volume and then add data/log files to the database. – Danilo Brambilla Jan 18 '12 at 9:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.