April 5

MSSQL: File extension definitions

.LDF is used for Log File

.TRN is used for backup of the transaction log.

.MDF is used for Data File

.BAK is used for backup of database (data and committed log)

By: Mak

Copyright 2021. All rights reserved.

Posted April 5, 2012 by Timothy Conrad in category "Databases

About the Author

If I were to describe myself with one word it would be, creative. I am interested in almost everything which keeps me rather busy. Here you will find some of my technical musings. Securely email me using - PGP: 4CB8 91EB 0C0A A530 3BE9 6D76 B076 96F1 6135 0A1B