Urgently Need help to get myself out of a mess

• Rootman

  SSCrazy

  Points: 2641

  More actions

  August 12, 2003 at 6:51 am

  #160547

  Hi,

  I accidentally killed a rollback (deleting data). Now my transaction log is massive, and I want to get rid of the stuff in there.

  I'm not bothered about the table, as I can should have truncated it.

  Can anyone help, please.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  August 12, 2003 at 7:04 am

  #469554

  Do you want to reduce the log file size?

  1. dbcc sqlperf(logspace) will tell you log file size and spaced used.

  2. backup log yourdbname with truncate_only to truncate the inactive transactions.

  3. dbcc shrinkfile(yourlogfilelogicalname, yourtargetsize) to reduce the log file size.

  For above commands, Refer to BOL for more details.