Because the plug-in backs up databases on the SAP ASE Server, which is constantly running, the plug-in does not back up the SAP ASE database startup parameters and environmental settings. Therefore, one of the following must take place to back up these necessary files:
• |
Take the SAP ASE Database offline and perform a backup of the database: With the database offline, these files are not active and are included in a standard backup of the database. |
• |
If a failure of the SAP ASE Database occurs, perform a backup of these files before attempting a recovery of the database: In this case, back up the files located in: “.../opt/sybase” |
Backup Selection Sets are essential for Incremental and Differential Backups. Create the Backup Selection Set during a Full Backup, and use it for Full, Incremental, and Differential Backups. The backup job reports an error if you do not use a Selection Set for the Incremental or Differential Backup. For more information, see the Quest NetVault Backup Administrator’s Guide.
1 |
2 |
In Job Name, specify a name for the job. |
3 |
4 |
In the list of plug-ins, open Plug‑in for SAP ASE to display the SAP ASE Server. |
• |
7 |
On the Sybase Login dialog box, enter the required login information so that you can browse the SAP ASE Server’s individual database items: |
• |
Account Name: Enter the account name assigned to the SAP ASE Server during its creation; that is, the account name that allows access to the SAP ASE Server for the backup or restore of its database information. The value entered as the Default Account Name in the Configure dialog box is displayed by default. |
• |
Password: Enter the password that corresponds to the account name entered in the previous field. |
8 |
Click OK. |
10 |
The next step involves creating the Backup Options Set or selecting an existing one.
1 |
2 |
• |
Full: Performs a complete backup of selected data. This option is the equivalent to the following SAP ASE ISQL command: DUMP DATABASE |
• |
Incremental: Performs a backup of the transaction log for the selected items. After the backup, these logs are truncated. This option is the equivalent to the following SAP ASE ISQL command: DUMP TRANSACTION. For more information, see Using Incremental Backups. |
• |
Differential: Performs a backup of the transaction log for the selected items. This option is the equivalent to the following SAP ASE ISQL command: DUMP TRANSACTION WITH NO_TRUNCATE. For more information, see Using Differential Backups. |
IMPORTANT: Before performing an Incremental or Differential Backup, a Full Backup of the same data must be performed. For information about how an Incremental or Differential Backup sequence affects the way restores are performed, see Restoring Incremental and Differential Backups. An Incremental or Differential Backup of a database is only possible when the data and log are configured to reside on different devices. An error occurs if both data and log reside on the same device and an Incremental or Differential Backup is attempted. This error occurs because the NetVault Backup Incremental and Differential Backups are equivalent to the Dump Transaction command of SAP ASE that backs up the transaction log. SAP ASE Server only supports the Dump Transaction command if the transaction logs reside on a different device than the data resides on. |
3 |
To save the set, click Save. |
4 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center