Administrator's Guide

G-3
Cisco Unified Attendant Console Administration and Installation Guide
OL-27293-02
Appendix G Backing-up and Restoring Cisco Unified Attendant Console Advanced
Backing-up Databases
Step 7 In the Subplan Properties dialog box, enter a meaningful Name and Description, and click the Schedule
calendar icon.
Step 8 In the Job Schedule Properties dialog box, select or specify the following:
• A Schedule type
• The job Frequency
• The Daily frequency (times) when the job must run.
Note We strongly recommend that you schedule this task to run out of working hours.
Step 9 Click OK.
Step 10 In the Subplan Properties dialog box, click OK.
Step 11 Drag an Execute T-SQL Statement Task from the Maintenance Plan Tasks toolbox and drop it into the
lower right-hand corner of the interface. You will use this task to shrink the transaction logs of both
databases.
Step 12 Click the task and rename it as required.
Step 13 Right-click the task and choose Edit, then enter the following into the T-SQL statement field:
Use ATTCFG
EXEC sp_dboption 'ATTCFG','trunc. log on chkpt.', 'true'
CHECKPOINT
DBCC SHRINKFILE (ATTCFG_log, 1,TRUNCATEONLY)
Use ATTLOG
EXEC sp_dboption 'ATTLOG','trunc. log on chkpt.', 'true'
CHECKPOINT
DBCC SHRINKFILE (ATTLOG_log, 1,TRUNCATEONLY)
Step 14 Click OK.
Step 15 Do the following for the configuration database (ATTCFG) and then repeat for the logging database
(ATTLOG):
a. Drag a Back Up Database Task from the Maintenance Plan Tasks toolbox and drop it below the
Execute T-SQL Statement Task.
b. Click the task and rename it as required.
c. Right-click the task and choose Edit.
d. We recommend applying the following settings:
– Set Backup Type to Full.
– In Database(s), click the down-arrow and select ATTCFG or ATTLOG, as appropriate.
– In Back up databases across one or more files, enter a file path and name.
Note If you save the back up files to your server’s local drive you must copy them to another location
to ensure they are still available if the server fails.
– Set If backup files exist to Overwrite.
e. Click OK.