Unanswered: the reason unexpected growth in mdf file and remedy for the same.
I have experienced a sudden increase in my database ie mdf ,since last 2 days hardly there is a 4mb of data being entered i found there is an increase of 400mb.
after shrinking the file its size reduces to 500mb but immidiately after it starts gradually increase upto a particular size of +500mb .
and transaction log file size increases upto 2gb.
can any body let me know the reason for this unexpected growth of mdf and ldf and remedy for the same.
i have run indexfrag in most of the indexes & restarted the sql server 2-3 time .
for info i observed the show-contig report and found fragmentation is under control.
prompt reply will be highly appriciated