{}

המותגים שלנו

Impact-Company-Logo-English Black-01-177x54

ברוכים הבאים לאתר האינטרנט של שניידר אלקטריק

ברוכים הבאים לאתר שלנו.
שאלות נפוצות
ION EEM: Transaction Log Backup Fails when SQL Server Recovery Model is set to Simple

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.

text

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.

שניידר אלקטריק ישראל

גלה עוד
טווח:
מאמרים שעשויים להיות מועילים
גלה עוד
טווח: