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.
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.
