Recovery Models

Two types of recovery are possible to back up the History Database:

  • Simple History Database backup
  • Full History Database backup

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