Cisco Cisco Agent Desktop 10.0 Installation Guide
Configuring Microsoft SQL Server
October 16, 2015
39
Configuring Microsoft SQL Server
CAD stores some historical information in Microsoft SQL Server. This information
provides the content for two reports available in Agent Desktop and Supervisor
Desktop (the Agent State Log and Agent Call Log) and the Supervisor Record Viewer.
SQL Server retains agent state information for one day and agent call log and
recording information for a rolling seven day period.
provides the content for two reports available in Agent Desktop and Supervisor
Desktop (the Agent State Log and Agent Call Log) and the Supervisor Record Viewer.
SQL Server retains agent state information for one day and agent call log and
recording information for a rolling seven day period.
You must purchase and install SQL Server and create a separate SQL Server instance
that hosts the CAD base services (on both servers in a replicated system). SQL Server
and CAD base services must be installed on the same machine.
that hosts the CAD base services (on both servers in a replicated system). SQL Server
and CAD base services must be installed on the same machine.
NOTE: Prior implementations of CAD 8.0, 8.5, and 9.0 supported the
use of flat files or Microsoft SQL Server as the data store. Flat files
are no longer supported with CAD 10.0. Customers who are
upgrading to CAD 10.0 from a previous version of CAD using flat files
must migrate to the version of SQL Server appropriate for their
version of CAD as the data store.
use of flat files or Microsoft SQL Server as the data store. Flat files
are no longer supported with CAD 10.0. Customers who are
upgrading to CAD 10.0 from a previous version of CAD using flat files
must migrate to the version of SQL Server appropriate for their
version of CAD as the data store.
SQL Server in a High Availability Configuration
In an HA configuration, the Recording and Statistics services write historical data to
the SQL Server databases that reside on the active and inactive sides. Also, SQL
Server replication services ensure that the data saved on both systems is identical.
the SQL Server databases that reside on the active and inactive sides. Also, SQL
Server replication services ensure that the data saved on both systems is identical.
Modifying the Database Size Limit
When the CAD base services are installed on the server, the maximum database size
for CAD is limited to 2GB. However, you can modify the database size as needed.
for CAD is limited to 2GB. However, you can modify the database size as needed.
To modify the database size limit:
1. Launch SQL Server Management Studio Express. The Microsoft SQL Server
Management Studio Express window appears.
2. Click New Query and select the CAD SQL named instance from the drop-down
list to connect to the CAD SQL named instance.
3. In the query pane, enter the following SQL statements and click Execute. In
this sample, the database size is reset to 1000 GB.
use master
alter database fcrassvr
modify FILE (NAME=FCRasSvr_Data,MAXSIZE=1000GB)
4. After executing the SQL statement, close the SQL Server Management Studio
Express window.