up vote 0 down vote favorite
share [g+] share [fb]

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)

link|improve this question
feedback

1 Answer

up vote 0 down vote
  • 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
link|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 at 8:57
1  
just add a new volume and then add data/log files to the database. – Danilo Brambilla Jan 18 at 9:45
feedback

Your Answer

 
or
required, but never shown
discard

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