Computer Associates BABWBR1151S38 Implementation Guide - Page 212

Fine-Tune the CA ARCserve Backup SQL Server Database To start the CA ARCserve Backup Database Protection Job 1. Open the CA ARCserve Backup Manager Console. From the Quick Start menu on the CA ARCserve Backup Home Page, select Job Status. The Job Status Manager window opens. 2. Select the Job Queue tab and find the Database Protection Job. Note: If the Database Protection Job was deleted, you can recreate the job using the steps in Recreate the CA ARCserve Backup Database Protection Job. Right-click the Database Protection Job and select Ready from the pop-up menu. The status of the Database Protection Job changes from Hold to Ready. A full backup of the database will be performed at the next Execution Time. 3. (Optional) To start the Database Protection Job now, right-click the Database Protection Job and select Run Now from the pop-up menu. The Database Protection Job starts now. Important! After you start the Database Protection Job, the Tape Engine will connect to a blank media in the first group that Tape Engine detects, and assign the media pool labeled ASDBPROTJOB. If the Tape Engine cannot connect to a blank media in the first group within five minutes, the Tape Engine will try to connect with blank media in the other groups sequentially. If the Tape Engine cannot connect to blank media, in any group, the job will fail. Note: For information about configuring devices and modifying the database protection job, see the Administration Guide. Fine-Tune the CA ARCserve Backup SQL Server Database The following sections describe how you can fine-tune your SQL Server installation to optimize performance. This section contains the following topics: How to Calculate the Number of Required SQL Connections (see page 213) Database Consistency Checks (see page 213) Specify ODBC Communication for Remote Database Configurations (see page 213) 212 Implementation Guide