Reply to post:

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

phuzz Silver badge

This ^^^ is the answer, for those of you who cannot for whatever reason do a full backup.

Change the database mode to simple, then run the shrink command on the log file, then change the mode back.

What you should do is a full backup, but if we all had the resources to stick to best practises all the time, then we'd all be a lot happier I expect.

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

Biting the hand that feeds IT © 1998–2019