Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2002

    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
    Last edited by ranjan; 09-04-02 at 09:11.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts