Restoring the Repository from Backups

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

1. Shut down Sybase Control Center.
2. Copy the most recent full backup from <SCC-install-directory>/backup/<generated_directory_name> to <SCC-install-directory>/services/Repository. For example:

   copy C:\sybase\SCC-3_2\backup\repository.270110161105\scc_repository.db 
   C:\sybase\SCC-3_2\services\Repository
   

3. If you have no incremental backups to load,
   1. Also copy the log file from <SCC-install-directory>/backup/<generated_directory_name> to <SCC-install-directory>/services/Repository. For example:

      copy C:\sybase\SCC-3_2\backup\repository.270110161105\scc_repository.log 
      C:\sybase\SCC-3_2\services\Repository
      

   2. Skip to step 5.
4. 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-install-directory>\services\Repository
   
   ..\..\bin\sa\bin_<platform>\dbsrv11.exe scc_repository -ad 
   <SCC-install-directory>\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.
5. Start Sybase Control Center.
   If you loaded incremental backups, SCC 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.

% cd C:\sybase\SCC-3_2\services\Repository

% ..\..\bin\sa\bin_windows32\dbsrv11.exe scc_repository -ad  
C:\sybase\SCC-3_2\backup\incremental