Home Forums Article Discussions Article Discussions by Author Discuss content posted by Tony Davis Stairway to Transaction Log Management in SQL Server, Level 5: Managing the Log in Full Recovery Mode RE: Stairway to Transaction Log Management in SQL Server, Level 5: Managing the Log in Full Recovery Mode

  • January 30, 2012 at 3:56 am

    #1439889

    Hi Peggy,

    Yes, I used .bak for all backup files in the article but as you say, the more common convention, which I should probably have followed, is to use .bak for database backups and .trn for transaction log backups.

    Cheers,

    Tony.