Managing the Database and Reporting › How to Protect the Arcserve Backup Database › Agent for Arcserve Database › Configure Backup and Restore Parameters for the Agent for Microsoft SQL Server Using the Backup Agent Admin

Configure Backup and Restore Parameters for the Agent for Microsoft SQL Server Using the Backup Agent Admin

Use the Backup Agent Admin utility to configure the Agent for Microsoft SQL Server backup and restore parameters for supported versions of Microsoft SQL Server. The parameters include settings for Microsoft Virtual Device Interface (VDI) objects and remote communication.

To configure backup and restore parameters for the Agent for Microsoft SQL Server using the Backup Agent Admin

1. Log in to the computer where the Agent for Microsoft SQL Server is installed.

   From the Windows Start menu, select All Programs, Arcserve, Arcserve Backup, Backup Agent Admin.

   The Arcserve Backup Agent Admin dialog opens.

2. Select Agent for Microsoft SQL Server from the drop-down list and click the Configuration icon.

   The appropriate configuration dialog opens.

3. On the Common Settings tab, specify the Level of Detail and Synchronized Recording under Agent Log Settings, as follows:
   • Level of Detail--Controls the settings for level of detail of the agent’s Activity Log and Debugging Log. For the Activity Log settings, a Level of Detail setting of Normal (0) includes basic information about agent activity. A setting of Detail (1) includes more detailed information about agent activity. A setting of Debug (2) enables the Debugging Log at a moderate level of detail. A setting of Trace (3) enables the Debugging Log at a very high level of detail. The Activity Log is localized for your reference. The Debugging Log is for Arcserve Support use, and is not available in multiple languages.
   • Synchronized Recording--Forces the log messages to be written to the Activity Log as they are posted. You can disable this option to improve the performance on high-load systems by caching several messages and writing them as a group.
4. Click Apply to apply the Common Settings.
5. On the Instance Settings tab, select the Instance (ARCSERVE_DB) or the name of the instance for which you wish to change configuration for the Agent for Microsoft SQL Server.
6. Set the parameters under Virtual Device Configuration as follows:
   • Number of Stripes--Determines the number of CPUs used to perform backups. Set this value to match the number of CPUs in the database server for the fastest backup performance. The default setting is 1 and the maximum value is 32.
   • Number of Buffers--The total number of VDI buffers (of maximum transfer size) used to back up and restore. The default setting is 1. This number cannot be less than the number of stripes.
   • Data Block Size (in bytes)--All data transfer sizes are multiples of this value. Values must be a power of 2 between 512 bytes and 64 KB inclusive. The default is 65536 or 64 KB.
   • Maximum transfer size--The maximum input or output request issued by Microsoft SQL Server to the device. This is the data portion of the buffer. This parameter value must be a multiple of 64 KB. The range is from 64 KB to 4 MB. The default setting is 2097152 or 2 MB.
   • Maximum VDI Wait Time - Backup (ms)--The time, in milliseconds, a Virtual Device object waits for a response from Microsoft SQL Server during a backup operation. This setting is also used by the agent when waiting for parallel operations to synchronize or background operations to complete, including during some parts of restore operations. The default setting is 60000 ms (ten minutes).
   • Maximum VDI Wait Time - Restore (ms)--The time, in milliseconds, a Virtual Device object waits for a response from Microsoft SQL Server during a restore. Increase this time if the database to be restored contains very large data files. The default setting is 9000000 ms (2.5 hours).
7. Under Named Pipes Configuration, specify the Maximum Connection Wait Time (ms) time, in milliseconds, the Agent for Microsoft SQL Server should wait to close a named pipe if a remote connection fails. The default setting is 400 ms.
8. Set the parameters under Restore Post-Processing Wait as follows:
   • Polling Period (seconds)--The amount of time to wait between checks of the database status. The default setting is 60 seconds (one minute).
   • Maximum Wait Timeout (minutes)--The total amount of time to wait before abandoning the waiting process. If this timeout elapses and the job contains additional Transaction Log sessions to be restored, then those additional sessions may fail to restore because SQL Server is not yet ready. The default setting is 180 minutes (three hours).

   Click Apply to apply the Instance Settings.

9. Click OK to end configuration.