Huge log file

• deepa_nandan

  SSC Enthusiast

  Points: 119

  More actions

  November 21, 2005 at 8:11 am

  #152630

  Hello,

  I am working on a SQL Server database that supports Macola application and here is what I found in one of the databases for my client:

  Data file is 142 MB where as the log file is 20000 MB, I think this may potentially be a problem so I want to make sure data is written from log to disk and log file is shrunk to manageble size. Please advise.

  Thanks a lot

  
  Raghu M Nandan

• srivas_c

  Newbie

  Points: 7

  More actions

  November 21, 2005 at 11:07 am

  #605015

  Hi,

  Just run the below command to reduce the log file size, Before running, Replace Northwind_log by ur logical filename.

  DBCC SHRINKFILE (Northwind_log, 10)

  go

  BACKUP LOG Northwind_log WITH TRUNCATE_ONLY

  After running the above command, Take complete backup of the database.

  Thanks

  Srini

  
  Srini

• AndrewMurphy

  SSCertifiable

  Points: 5586

  More actions

  November 22, 2005 at 1:55 am

  #605154

  This is a symptom of either the wrong backup strategy being in place, no backup strategy in place or the wrong 'failure recovery' model specified for the DB.  The solution proposed is temporary.  Investigate the needs of the DB and then implement the proper recovery model and the matchin DB backup strategy to make this permanent.

• deepa_nandan

  SSC Enthusiast

  Points: 119

  More actions

  November 22, 2005 at 5:31 am

  #605194

  Thanks a lot guys,

  Srini, your solution worked and I could reduce the transaction log...

  Andrew, I will take a look into this further and hopefully fix so that this does not happen again.

  Thanks again guys

  Raghu

  
  Raghu M Nandan