Recovery Models
Two types of recovery are possible to back up the History Database:
Long term storage databases are always in recovery model Full.
The following table shows a summary of the advantages and disadvantages of both recovery models. The backup mode you choose depends on how important historical data is for traceability purposes.
Recovery Models | ||
| Simple | Full |
Automatic data backup based on saved data volume | No | Yes |
Automatic data backup via scheduler program | Yes | Yes |
Small or no loss of data following SQL Server failure | No | Yes |
Simple restore of backed-up data by customer, engineer | Yes | No |
Restore backed up data requires SQL Server Management Studio (trained SQL Server administrator required) | No | Yes |
Installation and maintenance costs for data backup | Low | Higher |
PC performance required for data backup | Normal | High |