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:
Post a Comment