Modify, Create, and Submit a Custom Database Protection Job

This section describes how to modify or create a custom Database Protection Job from an existing Database Protection Job. This task helps to ensure that your Arcserve Backup database is backed up and is protected.

Prerequisite Tasks

Before proceeding, ensure that the following prerequisite tasks are complete:

• Ensure that the Tape Engine can detect at least one device in your environment. For more information, see "Managing Devices and Media."
• Ensure that the default Database Protection Job exists in the Job Queue. If the Database Protection Job does not exist in the Job Queue, you must recreate it. For more information, see Recreate the Arcserve Backup Database Protection Job.

To modify, create, and submit a custom database protection job

1. Open the Arcserve Backup Manager Console.
2. From the Quick Start menu on the Arcserve Backup Home Page, click Job Status.
3. The Job Status Manager window opens.
3. Click the Job Queue tab.
4. Locate and select the Database Protection job.
5. Note: If the Database Protection Job does not exist, you must recreate it. For more information, see Recreate the Arcserve Backup Database Protection Job.
5. Right-click the Database Protection Job and select Modify from the pop-up menu.
6. The Backup Manager window opens displaying the Start, Destination, and Schedule tab.
7. Note: When you modify the Database Protection Job, Arcserve Backup detects the type of database that is running in your environment (SQL Express 2008 or SQL Server) and specifies the database objects that are required to protect the database.
6. Perform one of the following steps:
   • Click the Destination tab and specify a location, media, or both where you want to store the backup data. For more information, see Options You Can Specify on the Backup Manager Destination Tab.
   • From the Start tab, click the Enable Staging check box.
   • The Staging Location and Policies tabs appear.
   • Click the Staging Location tab and specify where you want to stage the backup data. For more information about using staging, see Backup Staging Methods.
7. Click the Schedule tab and specify a schedule for the job. For more information, see Rotation Schemes.
8. Click Options on the toolbar.
9. The Global Options dialog opens.
9. Click the Operation tab.
10. Specify Append Backup of Arcserve Backup data at the end of job options required for your Arcserve Backup database:
    • SQL Server 2019 Express Edition--Required Options

For SQL Server 2019 Express databases, the following options are required and preselected for you:

• Arcserve Backup database--This option ensures that the Arcserve Backup database is backed up after jobs are complete.
• Job scripts--This option ensures that new and updated job scripts are backed up after jobs are complete.
• SQL Server Disaster Recovery Elements for Arcserve Backup database--This option ensures that the elements required to recover a SQL Server database from a disaster are backed up after jobs are complete.
11. SQL Server 2019 Express Edition--Optional Options

For SQL Server 2019 Express databases, the following options are optional:

• Catalog files--This option ensures that the Catalog files are backed after backup jobs are complete.
12. SQL Server--Required Options
13. For SQL Server databases, the following options are required and preselected for you:
• Arcserve Backup database--This option ensures that the Arcserve Backup database is backed up after jobs are complete.
• Job scripts--This option ensures that new and updated job scripts are backed up after jobs are complete.
14. SQL Server--Optional Options--
15. For SQL Server databases, the following options are optional:
• SQL Server Disaster Recovery Elements for Arcserve Backup database--This option ensures that the elements required to recover a SQL Server database from a disaster are backed up after jobs are complete.
• Catalog files--This option ensures that the Catalog files are backed after backup jobs are complete.
10. Click OK.
11. The Global Options dialog closes and the Operation options are applied.
11. Click Submit on the toolbar to submit the job.
12. The Submit Job dialog opens.
12. From the Submit Job dialog, enter a description for your job and click OK.
13. The Database Protection Job is submitted.