Cisco Cisco Agent Desktop 9.0 Guida All'Installazione
Configuring Microsoft SQL Server 2008 R2 for CAD 9.0
August 4, 2014
41
Configuring Microsoft SQL Server 2008 R2 for
CAD 9.0
CAD 9.0
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 2008 R2 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.
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.
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. As a matter
of policy, effective immediately with release 9.0(3), all customers with
new deployments of any version of Cisco Agent Desktop must use
SQL Server as the data store, and not flat files. The rationale behind
this policy is that deployments with a fully replicated SQL Server
database experience a more complete feature set and better
performance and stability.
use of flat files or Microsoft SQL Server as the data store. As a matter
of policy, effective immediately with release 9.0(3), all customers with
new deployments of any version of Cisco Agent Desktop must use
SQL Server as the data store, and not flat files. The rationale behind
this policy is that deployments with a fully replicated SQL Server
database experience a more complete feature set and better
performance and stability.
Customers who are upgrading to CAD 9.0(3) from a previous version of CAD
that was run on Windows Server 2003 (CAD 7.5, 7.6, 8.0, 8.5(1), and 8.5(2a))
must migrate to SQL Server 2008 R2 as the data store.
that was run on Windows Server 2003 (CAD 7.5, 7.6, 8.0, 8.5(1), and 8.5(2a))
must migrate to SQL Server 2008 R2 as the data store.
Customers who used flat files with CAD 8.5(4) and CAD 9.0(1a) running on
Windows Server 2008 R2 can continue to use flat files when upgrading to
CAD 9.0(3), but are also encouraged to migrate to SQL Server 2008 R2. CAD
documentation outlines the caveats associated with the use of flat files,
including loss of functionality during fail over situations that might be cause
by several reasons, network issues being the most common. Cisco Support
and TAC reserves the right to request a migration to SQL Server 2008 R2 as a
resolution plan.
Windows Server 2008 R2 can continue to use flat files when upgrading to
CAD 9.0(3), but are also encouraged to migrate to SQL Server 2008 R2. CAD
documentation outlines the caveats associated with the use of flat files,
including loss of functionality during fail over situations that might be cause
by several reasons, network issues being the most common. Cisco Support
and TAC reserves the right to request a migration to SQL Server 2008 R2 as a
resolution plan.
See
for information on supported versions of
SQL Server.
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.