Cisco Cisco Agent Desktop 8.5 설치 가이드
SQL Server Database
February 21, 2013
143
SQL Server Database
If you choose to use a SQL Server database to store CAD data, you must purchase and
install SQL Server and create a SQL Server instance yourself. SQL Server can be
installed on any server in your configuration.
install SQL Server and create a SQL Server instance yourself. SQL Server can be
installed on any server in your configuration.
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.
Modifying the Database Size Limit
When the CAD 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.
CAD is limited to 2GB. However, you can modify the database size as needed.
To modify the database size limit:
1. Click Start > All Programs > Microsoft SQL Server 2005 > SQL Server
Management Studio Express. The Microsoft SQL Server Management Studio
Express window appears.
Express window appears.
2. Click New Query and select the CADSQL named instance from the drop-down
list to connect to the CADSQL 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.