Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012
    Posts
    7

    Question Unanswered: Log File Auto shrink 'Yes' is good option?

    Is Auto shrink is good option where databse is very critical and there is no down time?

    Ths
    Niks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    No. You'd be asking for large amounts of disk fragmentation.

  3. #3
    Join Date
    Apr 2012
    Posts
    7

    Lightbulb

    Actually, Log file consuming more then 90%, what would be the best option to tackle it?

    Regds
    Niks

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Perhaps backing up the log once in a while?

Tags for this Thread

Posting Permissions

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