Log file resize

• Ravi_Nandha

  Grasshopper

  Points: 12

  More actions

  December 9, 2002 at 10:16 am

  #58238

  Hi,

  Due to autogrow parameter setting, the transaction log file got 2GB size. Is there a way to shrink it back to 100 or 200 MB ?

  I appreciate your response.

  Ravi

• don1941

  SSCarpal Tunnel

  Points: 4183

  More actions

  December 9, 2002 at 10:27 am

  #443802

  See "Shrinking the Transaction Log" in BOL.

  you will end up truncating your log and using DBCC ShrinkFile.

  Be sure to set autogrow to a reasonable size or turn it off.

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  December 9, 2002 at 10:56 am

  #443811

  In SQL7 I have never been able to shrink log files even by following BOL. I always detach and re attach my databases.

  Far away is close at hand in the images of elsewhere.
  Anon.

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  December 9, 2002 at 11:05 am

  #443814

  Have you ever tried running this script prior to shrinking the log file:

  http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP

• Ravi_Nandha

  Grasshopper

  Points: 12

  More actions

  December 9, 2002 at 12:27 pm

  #443829

  Thanks friends for your timely help.

  Ravi.