Previous Topic: Specify Microsoft SQL Server 2014 Express Backup Options for the Arcserve Backup DatabaseNext Topic: Start the Arcserve Backup Database Protection Job


Specify Microsoft SQL Server Backup Options for the Arcserve Backup Database

Arcserve Backup lets you protect the Arcserve Backup database using full, incremental, and differential backup methods. This capability lets you use rotation schemes and schedules to protect the database. Additionally, Arcserve Backup lets you back up only the transaction log and check the consistency of the database before the backup job starts or after the backup job completes.

Note: For information about how to protect Microsoft SQL Server databases that do not function as the Arcserve Backup database, see the Agent for Microsoft SQL Server Guide.

Follow these steps:

  1. Open the Backup Manager windows, select the Source tab, and expand the Windows System object and locate the server that is hosting the Arcserve Backup database.

    The server hosting the Arcserve Backup database can be a primary server, a member server, or a remote system. If the server hosting the Microsoft SQL Server database does not appear in the Backup Manager directory, you must add the server to the directory tree under the Windows Systems object before continuing. For more information, see Back Up Remote Servers.

    Note: To specify SQL Server backup options, you must authenticate using Windows or SQL Server credentials.

  2. Expand the server, right-click the Arcserve Backup database object, and select Agent Option from the pop-up menu.

    The Agent Backup Option dialog opens.

  3. From the Agent Backup Option dialog, specify the options that you require to protect the database.

    The following backup methods are provided:

    The following Database Subset options are provided:

    The database subset backs up selected files in a database. Use this option to back up a file or FileGroup when the database size and performance requirements do not allow you to perform a full database backup.

    Note: The Database Subset options are disabled if the selected Backup Method is Transaction Log Only.

    The following Log Truncation Options are provided:

    The following database consistency options are provided:

    A DBCC tests the physical and logical consistency of a database. DBCC provides the following options:

    The following miscellaneous options are provided:

  4. Click OK.

    The Agent Backup Options are applied.