Shrinking a Log File

• Jason Delaune

  SSCrazy

  Points: 2649

  More actions

  March 18, 2002 at 9:39 am

  #78489

  I have just inherited a database with a log file size of 3.5GB, but the actual data used in the log file is only about 70MB. I have tried the DBCC SHRINKFILE command, but the log file still will not shrink even after numerous log backups and database backups. Can someone help me here? What am I missing?

  Jason

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 18, 2002 at 10:30 am

  #425548

  Is this SQL 7 or 2K?

  Try this,

  BACKUP LOG [dbnamehere]

  WITH TRUNCATE_ONLY

  Then see (http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1) for a script to help force the log size down.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

• Jason Delaune

  SSCrazy

  Points: 2649

  More actions

  March 18, 2002 at 10:56 am

  #425555

  Thanks!!! That script did the trick.

  Jason