Cannot back up transaction log for this database

Error code

Product

Applies to

BA1515

BackupAssist

BackupAssist Version 4 or later

Description

For SQL 2005, 2008/R2, 2014 & 2016
Navigate to the SQL Server Management Studio > right click on the database > select properties > select the Options page > set the Recovery model to Full

For SQL 2000
Navigate to SQL enterprise manager; right click on the database > go to properties > options tab > set the recovery model to full. If the databases are in Simple recovery mode, they cannot be included in a Transactional Log backup. Please change the recovery mode to Full in case you wish to perform a T-log backup for this database.

Last updated

Created

Further assistance

02nd Sep 2009

16th Mar 2007

BackupAssist Support page