Specify Microsoft SQL Server 2019 Express Backup Options for the Arcserve Backup Database

Arcserve Backup can use full and differential backup methods when backing up Microsoft SQL Server 2019 Express databases. This capability lets you use a rotation scheme or a schedule when backing up the Arcserve Backup database. Additionally, Arcserve Backup lets you check the consistency of the database before the backup job starts or after the backup job is complete.

To specify Microsoft SQL Server 2019 Express backup options

1. Open the Backup Manager windows, select the Source tab, and expand the Windows System object to locate the Arcserve Backup primary server.
2. Expand the Primary server, right-click the Arcserve Backup Database object, and select Agent Option from the pop-up menu.
3. The Agent Backup Option dialog opens.
3. From the Agent Backup Option dialog, specify the options that you require to protect the database.
   • Specify one of the following Backup Methods:
   • Use Global or Rotation Options--Select this option to perform a full or differential backup based on the global job method or rotation phase. The Incremental job method or rotation phase results in a Differential backup.

   Note: This is the default backup option.

   • Full-- Select this option to perform a full backup every time the job is run. When you perform a full backup, Arcserve Backup performs a full backup of the three system databases, the 24 Arcservedatabases, and records a synchronization checkpoint. Arcserve Backup creates two backup sessions. One session will contain the disaster recovery elements. The other session will contain all of the data that is required to restore the Arcserve Backup database.
   • Differential-- Select this option to perform a differential backup every time the job is run. When you perform a differential backup, Arcserve Backup performs a differential backup of the 24 Arcserve databases and records a synchronization checkpoint. Arcserve Backup creates one backup session containing all of the data that is required to restore the Arcserve Backup database.
   • Specify the Database Consistency Check (DBCC) options that you require. DBCC options let you check the allocation and structural integrity of all the objects in the specified databases.
     • Before backup--Select this option to check the consistency of the database before the backup starts.
     • After backup--Select this option to check the consistency of the database after the backup completes.
     • Continue with Backup, if DBCC fails--Select this option to continue the backup even if the check before backup operation fails.
     • Do not check indexes--Select this option to check only the system tables.
     • Check the physical consistency of the database--Select this option to detect torn pages and common hardware failures. In addition, it checks the integrity of the physical structure of the page and record headers, and the consistency between the page’s object ID and index ID.
   • Example: How DBCC Options Work
   • The following example illustrates how DBCC options work with Override Global Options on the Agent Backup Options dialog.
     • With Override Global Options specified, the DBCC options selected at the database level will be the only DBCC options specified.
     • With Override Global Options not specified, all of the DBCC options specified for the database and all the DBCC options selected in the Global options will be applied together.
   • On the Global Options/Agent Options tab, the DBCC options that follow are specified:
     • After backup
     • Do not check indexes
   • On the Agent Backup Options dialog, Override Global Options is not selected and the DBCC options that follow are specified:
     • Before backup
     • Continue with backup, if DBCC fails
   • When you submit the backup job, Arcserve Backup applies the DBCC options specified in logical order: Perform the DBCC before the backup starts. If the DBCC fails, perform the backup. After the backup is complete, do not check the indexes.
   • Override Global Options--Lets the agent ignore all checkbox-based options from the Global Agent Options tab for only the specified database.

   Note: The Backup Method is not affected by this option because it can be overridden separately. This option is available only on a per-database basis.

4. Click OK.