Cisco Cisco TelePresence Management Suite (TMS) Version 15 Installation Guide
Identifying or Changing the Recovery Model
To identify or change the recovery model of your database, see the Microsoft instructions for your version of
SQL Server:
SQL Server:
■
(SQL Server 2012)
■
Regular Maintenance Tasks
As a best practice, set up regular maintenance tasks for backups and index maintenance. Beware that database main
tenance impacts Cisco TMS performance. Perform these tasks during your organization's scheduled maintenance
windows.
tenance impacts Cisco TMS performance. Perform these tasks during your organization's scheduled maintenance
windows.
Backup
Set up tasks to back up the server in accordance with your organization's recovery policies, and once per week as a
minimum:
minimum:
■
(SQL Server 2012)
■
Index Maintenance
Perform maintenance on the database indexes at regular intervals to avoid excessive fragmentation. We suggest
rebuilding the indexes monthly, or when fragmentation goes past 30%.
rebuilding the indexes monthly, or when fragmentation goes past 30%.
■
■
(SQL Server 2008 R2)
SQL Server Maintenance Plan
If using the full version of SQL Server (not Express), built-in maintenance plan features and a wizard are available for
tasks like the above. For guidance, see the following Microsoft articles:
tasks like the above. For guidance, see the following Microsoft articles:
■
(SQL Server 2012)
■
Database Size Management
We strongly recommend against having a regular maintenance task for shrinking the database. Over time, the data
base size will normally stabilize, and can be specified as a fixed size with an added 30% buffer.
base size will normally stabilize, and can be specified as a fixed size with an added 30% buffer.
On some occasions, the database size may grow significantly during an upgrade. In these cases, we recommend a
one-time operation to shrink the database.
one-time operation to shrink the database.
Security
This section presents recommended and suggested measures to make your Cisco TMS deployment more secure.
Web and API Communication
By default, the Cisco TMS installer will set up HTTPS for web communication, offering to create a self-signed cer
tificate if the administrator does not provide one. For improved security, we strongly recommend using valid
tificate if the administrator does not provide one. For improved security, we strongly recommend using valid
19
Cisco TelePresence Management Suite Installation and Upgrade Guide
Deployment best practices