Goals and Symptoms
Summary
For the ION_EEMData database, the transaction log backup will not work if the recovery model is set to, "Simple." It will work if set to "Full" but review the ION EEM Deployment Guide (RESL197759) in the section regarding, "Configuring Database Settings" before making any changes. When the recovery model is set to, "Simple," the following error message will be shown in the backup log:
Starting maintenance of database 'ION_EEMData' on 11/17/2009 12:50:17 AM
Backup can not be performed on database 'ION_EEMData'. This sub task is ignored.
Deleting old text reports... 0 file(s) deleted.
End of maintenance for database 'ION_EEMData' on 11/17/2009 12:50:17 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Facts and Changes
Keywords
ION EEM, Transaction Log, Backup, SQL Server, Recovery Model, Simple
Causes and Fixes
Cause
For the ION_EEMData database, the transaction log backup will not work if the recovery model is set to, "Simple." The simple recovery model allows you to recover data only to the most recent full database. Transaction log backups are not available because the contents of the transaction log are truncated each time a checkpoint is issued for the database.
Resolution
For the ION_EEMData transaction log backup to work the recovery model must be set to, "Full." Please refer to the ION EEM Deployment Guide (RESL197759) in the section regarding, "Configuring Database Settings" before making any changes as there may be effects that are not desired.