0

Is it possible to reduce the initial log-file size of a DB. See the screen-shoot below, the log-file shouldn't be more than 500 MB with an autogrowth of 100 MB. I dont want to shrink the file, i want to reduce the allocated space to 500 MB. How do i do it?

enter image description here

itsAftab
  • 159
  • 1
  • 2
  • 6

1 Answers1

0

Depend on your database activity and database recovery mode you can manage TLOG size in different ways.

First of all to reduce TLOG usage you have to make transactions smaller.

If the database is in FULL recovery mode, do TLOG backups often.

As lots of guru's say - don't touch TLOG and TempDB they grew as they need to.

Oleg Strutinskii
  • 223
  • 2
  • 13