SQLUSA
Free Trial Save on Combos
SQL Server 2008 Best Practices
SQL Server 2005 Best Practices
SQL Server 2000 Best Practices
How to name backup file extensions?

As a standard you can implement the following file extension naming convention for SQL Server database backup files:

/* File extensions for SQL Server backups

 

Full Database Backup      - *.bak

Transaction Log Backup    - *.trn

Differential Backup       - *.dif

Filegroup Backup          - *.fil

 

*/

NOTE: file extension or filename extension are frequently misspelled as extention.

 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page