Polycom 3725-77601-001H manual Database Operations, Database Restoration, From

Database Operations

Database Restoration

This section describes how to restore an internal CMA system database. To restore from an external Microsoft SQL Server databases, use Microsoft SQL Server Management Studio. Refer to your Microsoft SQL Server Management Studio documentation for more information.

You can migrate databases as follow.

From...

Internal

Internal

External

To...

Internal

External

External

When you restore internal or external databases:

•Do not allow users to connect to the server during the restoration process.

•Restore all of the system databases at the same time.

•Restore all of the system databases from backups that were taken at the same time.

•Restart the CMA system server when the restoration process is finished.

Database Operations

Before performing the database operations described here, Microsoft SQL Server should already be installed. (For information about the supported Microsoft SQL Server applications and service pack levels, see the Polycom CMA System Release Notes for the version you’re running.)

The Microsoft SQL Server Setup wizard and documentation provides guidance for setting up Microsoft SQL Server. As you use the wizard, make these choices:

•For Components to Install, at a minimum choose the SQL Server Database Services.

•For Instance Name, select Default Instance and configure the database instance port (typically 1433).

•For Service Account, select the Use the built-in System account option.

•For Authentication Mode, select Mixed Mode and provide a password that meets your enterprise policy for password length and complexity.

•For Collation Settings, select SQL collations. The CMA system is only certified with the Microsoft SQL Server set to US-English Collation (SQL_Latin1_General_CP1_CI_AS).

Polycom, Inc. 427