Tuesday, January 29, 2008

Cleaning up transaction log from database

I had a problem with cleaning up logfiles from some database.
But when the script does not work you have to search an other way.

I found a solution to clean up the logfiles, it's not a neat one but it works.

Follow these 3 steps:
  • Detach the database
  • rename the LDF
  • Attach again.
    It will alert you to the fact that there's no log file, and will create a fresh one for you.
    (The log file has shrunk from 1Gb to 700k)

No comments: