Reply to post:

Junior dev decides to clear space for brewing boss, doesn't know what 'LDF' is, sooo...

Doctor Syntax Silver badge

"Why would database software be written such that deleting an ancillary file ( such as a log file of historic steps) cause it to fall over?"

Not familiar with that particular engine but one possibility is that it contains the log of current transactions, i.e. WORK that's STARTed but not yet COMMITted or ROLLed BACK. That puts the engine in a bit of a quandary as to what it's working on. The longer term need for the logs is to roll the database forward after a restore from backup and there ought to be a means of archiving logs for use as and when required instead of letting them grow indefinitely.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon