Filter
Top Products
Database Operations
Polycom, Inc. 427
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.
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).
From... To...
Internal Internal
Internal External
External External