We have a SQL database with a full recovery model that backs up the database once a day, along with hourly backups for the transaction logs. However, we only have one transaction log backup file, and it is overwritten every time. Are transaction log backups cumulative, and if so, does that one file contain all transactions since the previous database backup? Also, what is the correct extension for a transaction log backup?
September 19, 2008 4:50 PM
September 23, 2008 5:46 PM