Overgrown Log Files

• maximus.emeka

  SSC Enthusiast

  Points: 114

  More actions

  June 4, 2008 at 4:07 am

  #380911

  Please i need an assistance on how to shrink my log files which has grown so big that it takes about 45 mins for me to copy the log and data files.

  Maximus

  Nigeria

• Deepak-405225

  SSCertifiable

  Points: 6120

  More actions

  June 4, 2008 at 4:22 am

  #824071

  Take transaction log backup using the below command,

  Backup log dbname to disk='Path\filename.trn'

  Shrink the log file using the below command,

  Use yourdb

  go

  Dbcc Shrinkfile('logfilename',500)

  go

  [font="Verdana"]- Deepak[/font]