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 |