transaction log to large!!! (can't shrink file)

• Jhun G

  SSC-Addicted

  Points: 463

  More actions

  May 26, 2003 at 2:06 am

  #105660

  i have a 1 gigabyte of Database file and a 8 gigabyte of Transaction log file... i can't seem to shrink the transaction log file into a more acceptable size , i tried using shrinkfile but it doesn't work. I regulary backup my database, but it seems to me that the transaction log is still getting bigger.

  I am having trouble backing it up into another medium because of the huge transaction log, can someone advice me on this,

  many thanks

• Levi Justus

  SSCommitted

  Points: 1923

  More actions

  May 26, 2003 at 3:17 am

  #458480

  Hi..

  Please truncate the transaction log before shrinking the Logfile..check the below command to do it.

  dump tran Database_Name with no_log

  Now use the dbcc shrikfile command.

  levi

  
  Jesus My Saviour