Cisco Cisco Unified MeetingPlace Audio Server Quick Setup Guide

Page of 766
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
Updating the Indices on the SQL Database
25
 
b.
Select Admin.
c.
Select Web Server.
d.
Update appropriate fields, such as the Web Server Hostname.
Related Topics
  •
 
  •
 
  •
Updating the Indices on the SQL Database
The SQL database needs regular maintenance. If the SQL database is running slowly, or if the SQL 
database is running on a remote SQL server, then you should run this procedure on a nightly or weekly 
basis.
Procedure 
Step 1
Launch SQL Enterprise manager. 
Step 2
Select the Cisco Unified MeetingPlace Web Conferencing database, which is named something similar 
to MPWEB_<GUID_ID>_<Location>.
<Location> can be either 1 or 2, depending on whether this is an internal or an external Web Server.
Step 3
Select Tools > Wizards from the menu options at the top of the window. 
Step 4
Expand on the Management option.
Step 5
Select Database Maintenance Plan Wizard
Step 6
Select Next on the Welcome to the Database Maintenance Plan Wizard page. 
Step 7
Select the database on the Select Database page, then select Next
Step 8
Check Reorganize data and index pages on the Update Data Optimization Information page, then 
select Next
Step 9
(Optional) Change the schedule on which this maintenance procedure runs. 
Step 10
Select Next on the Database Integrity Check page. 
Step 11
Uncheck Backup the database on the Specify the database backup plan page, then select Next
Step 12
Select Next on the following pages:
  •
Specify backup disk directory page
  •
Specify the transaction log backup plan page
  •
Reports to generate page
  •
Maintenance Pan History page
Step 13
Select Finish on the Completing the maintenance plan wizard page.