how to shrink logfile ?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  December 4, 2012 at 7:10 am

  #1565308

  arunyadav007 (12/3/2012)

  ---

  If not, you can try this

  USE MASTER

  GO

  DBCC FREESESSIONCACHE WITH NO_INFOMSGS

  GO

  DBCC FREESYSTEMCACHE 'ALL'

  GO

  USE (YOURDBNAME)

  GO

  DBCC SHRINKFILE (N'LOGFILENAME', 0, TRUNCATEONLY)

  GO

  DBCC SHRINKFILE (N'LOGFILENAME' , 1024)

  GO

  Well, I suppose that you can try that, but since none of those will help in the slightest with a full transaction log and may in fact make the scenario worse, I personally would recommend that you don't try any of those commands.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass