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.
| Author |
Topic |
|
prasad0482
Starting Member
12 Posts |
 Posted - 2010-08-18 : 07:14:36
|
| Hi my database size is grown up very fast how can stop fast growing.yesterday 8 gb, but today morning i have checked it showing 9gb. how can i control database size growing fast.KinregardsPrasad. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-18 : 08:30:38
|
| check the growth rate of the database, is it by 1 GB ?check if there is data added to merit the 1 GB growth, sp_spaceused will give you an idea, issue it again the following day--------------------keeping it simple... |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-08-19 : 16:12:00
|
| How are you checking the size? Is it perhaps the log file that is continuing to grow? If so, check the recovery model of the database. If the recovery model is full - you need to be performing frequent (every 15 minutes) transaction log backups.Jeff |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-20 : 01:57:01
|
| What is the size of the MDF and LDF files? If the LDF is much MUCH larger than the MDF file then most probably Transaction Backups are not happening. |
|
|
|
|
|
|
Database size grownup