Restoring the Repository from Backups

Load backup files into the repository database to revert undesirable changes or to recover from a catastrophic failure.

Context

If you configured SAP Control Center to store backups somewhere other than the default location, change the source directory in the copy commands in this procedure.

Procedure

Shut down SAP Control Center.
Copy the most recent full backup from <SCC_HOME>/backup/<generated_directory_name> to <SCC_HOME>/services/Repository. For example:
```
copy C:\SCC_HOME\backup\repository.270110161105\scc_repository.db 
C:\SCC_HOME\services\Repository
```
If you have no incremental backups to load,
1. Also copy the log file from <SCC_HOME>/backup/<generated_directory_name> to <SCC_HOME>/services/Repository. For example:
```
copy C:\SCC_HOME\backup\repository.270110161105\scc_repository.log 
C:\SCC_HOME\services\Repository
```
2. Skip to step 5.
(Optional) To load incremental backups, start the repository database using the -ad option, which directs it to load transaction logs (incremental backups) from the incremental directory. (The database loads full backups automatically.) For example:
```
cd SCC_HOME\services\Repository

..\..\bin\sa\bin_<platform>\dbsrv11.exe scc_repository -ad 
SCC_HOME\backup\incremental
```
The repository database loads the full backup and any subsequent incremental backups present in the incremental directory. Incremental backups are loaded in date order. After loading and saving, the database shuts down.
Start SAP Control Center.
If you loaded incremental backups, SAP Control Center starts normally (that is, no further recovery occurs). If you copied a full backup to the Repository directory, the database recovers the repository from the full backup.

Example

Example: Loading incremental backups into the repository database

These commands start SQL Anywhere® on a 32-bit Windows machine:

% cd C:\SCC_HOME\services\Repository
% ..\..\bin\sa\bin_windows32\dbsrv11.exe scc_repository -ad  
C:\SCC_HOME\backup\incremental