SQL Server Performance

MS SQL 2005 backup extension: .bak,. trn, .full

Discussion in 'Getting Started' started by shawn, Feb 1, 2010.

  1. shawn New Member

    I have a simple question, sometime I see different extensions on MS SQL 2005 backup like : bak,. trn, .full
    What is the difference between them?
    Thank you.
  2. preethi Member

    SQL Server does not expect any particular extension for backups. Some client tools however, have a default extension. Generally .bak is used for full and differential backups and .trn is used for transaction log backups. I have not heard of .full extension, but it could be used by some vendors. However, you can use any extension or create backups without extension.
    Do not relay on the extension to determine the type of backup.
    Hope this helps.
  3. shawn New Member

    Thank you for the explanations, that confirm what I thought.

Share This Page