• Steve Jones - SSC Editor (4/22/2013)


    If you're loading 1-2 GB a day in the log, I'd shrink the log to 5GB. Space is relatively cheap, and this gives you pad.

    You don't need a 140GB log, and likely it grew because you didn't run log backups. Switch the db to simple mode, shrink the log. Schedule (don't run, schedule) a full backup every day.

    Steve while shrinking log Should i select option of release unused space or shrink to X GB?