Maintaining Surround SCM databases

It is important to perform regular backups and routine maintenance tasks on Surround SCM databases.

Backups

The Surround SCM Server database and mainline branch databases should be backed up regularly. See Backing up Surround SCM databases.

Routine maintenance for PostgreSQL databases

Surround SCM PostgreSQL databases need to be maintained regularly. Perform the following maintenance tasks on a regular basis:

1. Vacuum the database

2. Rebuild the database index

3. Maintain the log files

See Maintaining Surround SCM PostgreSQL databases for more information.

It is always a good idea to carry out proper routine maintenance on any database system. Ask your DBA for help with maintenance for other database types.

Resolving database issues

If you notice a slowdown in Surround SCM performance or if database errors are written to the server log, you can analyze databases to identify and repair issues. See Resolving database issues.