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 |
|
ermahesh2009
Starting Member
2 Posts |
 Posted - 2012-11-21 : 04:06:49
|
| Mdf file SIZE GROWING EXPONTAILLY within seconds WHILE LDF FILE NOT .MAHESH |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-21 : 04:12:24
|
| Is the Recovery Model simple? That makes sense.What is the question?-Chad |
 |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-11-21 : 06:23:49
|
| It means you are inserting huge data to your table(s)/database. Change the properties of Database and set the recovery model to simple. If it still doesn't work exec sp_spaceused and post the results to investigate further. |
|
|
|
ermahesh2009
Starting Member
2 Posts |
Posted - 2012-11-21 : 07:09:50
|
| database_name database_size unallocated space-------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------KCSOLITAIRE_LIVE_251012 52.25 MB 3.75 MBreserved data index_size unused------------------ ------------------ ------------------ ------------------48640 KB 40024 KB 5872 KB 2744 KBMAHESH |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-11-21 : 09:35:23
|
| How is it growing exponentially?? I don't see that |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-11-21 : 15:37:09
|
| I don't even understand the problem. If you have log maintenance set up, or run in simple recovery, your data file will grow, and your log won't. That is normal.-Chad |
|
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-11-21 : 23:30:48
|
| Hi Mahesh,What are you expecting from this post; 48MB is not a big deal and I don't think it is growing exponentially. Log files will not grow with respect to your mdf files, if it is so then there's a problem else this is expected.Thanks,Sri. |
|
|
|
|
|
|
Mdf file SIZE GROWING EXPONTAILLY within se