Posted on 2004-08-30
I accidentally deleted the LDF file. Now I can't access the database. What can I do? Can I generate the LDF from the MDF? Also, the MDF and LDF continous to grow bigger and bigger. How can I control them? If I limit the LDF size, the old transactions log will be deleted automatically and new transactions log will replace the old one when the file size reach the limited? How about the MDF, can I compact it like Access?