Polycom 3725-77601-001H manual Internal Databases, External Databases

Polycom CMA System Operations Guide

The Simple Recovery Model should be enabled for SQL backup mode.

Internal Databases

The CMA system automatically optimizes its internal database on an ongoing basis. It backs up its internal databases daily. The backup files are stored on the system’s hard disk. The CMA system maintains the last four internal backups. To keep backups for a longer time period, copy them regularly to a different location. For more information, see “Copy the CMA System Database Backup Files” on page 428.

External Databases

You can integrate the CMA system to an external Microsoft SQL Server database. Some information about integrating with an external database:

•CMA systems with 400 or more registered endpoints and redundant systems require an external database.

•If you set up an external database, follow your own corporate policies (or Microsoft best practices) to back it up and maintain it. The CMA system does not back up its external databases.

•Anytime you switch from the internal CMA system database to an external Microsoft SQL Server database, some system configuration settings, for example the enterprise directory settings, must be reconfigured.

•Take steps to minimize database connection failures. For example:

—Ensure you have good network connectivity between the CMA system and the Microsoft SQL Server. You may even consider co-locating the CMA system with your Microsoft SQL Server.

—Increase the keep alive checks on the Microsoft SQL Server to once an hour.

•If your system does lose connection to the database, you must reboot the CMA system to restore login capability; the CMA system does not automatically reconnect to the database. For more information, see “Restart or Shut Down a Polycom CMA System” on page 6.

•It is recommended that anytime you reboot the external database server, you also restart the CMA system in the same maintenance window.

•You can create the CMA system databases manually using Microsoft SQL scripts. Contact Polycom Global Services to request the scripts.

•Anytime you switch from database sources (internal to external or external to internal), the default administrator’s password is moved to the database as part of the switch.

426 Polycom, Inc.