Wednesday, December 10, 2008

Clear Transaction Log in SQL Server 2005 database

  1. Backup DB
  2. Detach DB
  3. Rename Log file
  4. Attach DB
  5. New log file will be recreated
  6. Delete Renamed Log file.

Above just is 1 of the way to clear the transaction log file