The procedures in this section are a generic example of how to set up archive and restore scripts for selected partitions. This example is based on the TransactionHistory table previously described.
Assume that this backup schedule is desired for the TransactionHistory table:
- An incremental backup of the currently active partition will be done nightly.
- At the beginning of each month, the final incremental backup for the previous month will be done; this backup will be saved until the next differential or full-table backup is done.
- Every three months, a differential backup will be done, containing the data for the last three months.
- Every year, a full-table backup will be done.