Reply to post: It's not ancillary, it's a critical part of the database

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

David Harper 1

It's not ancillary, it's a critical part of the database

The transaction log file is NOT an "ancillary" part of the database. It's a critical file, which is just as important as the data files, since the state of the database is represented by the combination of data files AND transaction log file. The transaction log file contains changes to the data that have been committed, but that may not have been applied to the data files yet.

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