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

4 comments:

Rune4440 said...

Then please post the others

Alishana said...

WoW nice blog buddy!Actually WoW is my favorite appreciation keyword.I also like to play. Wow Gold. I was looking for info regarding that and saw your website. Its nice and very interesting.

mindbees said...

Aion kinah



Fantastic one

mindbees said...

wow gold kaufen


Nice blog,read