Polycom Welding System 3725-77601-001H Manual Do Utilizador

 

Database Operations

Polycom, Inc. 

427

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.

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).

Internal

Internal

Internal

External

External

External