Chatee ahora con Soporte
Chat con el soporte

NetVault Plug-in for Sybase 11.4.5 - User Guide

Backing up data

Important considerations

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”

Selecting data for a backup

You must use sets — Backup Selection Set, Backup Options Set, Schedule Set, Target Set, and Advanced Options Set — to create a backup job.

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.

TIP: To use an existing set, click Create Backup Job, and select the set from the Selections list.
1
In the Navigation pane, click Create Backup Job.
You can also start the wizard from the Guided Configuration link. In the Navigation pane, click Guided Configuration. On the NetVault Configuration Wizard page, click Create backup jobs.
2
In Job Name, specify a name for the job.
3
Next to the Selections list, click Create New.
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
10
Click Save, enter a name in the Create New Set dialog box, and click Save.

Setting backup options

The next step involves creating the Backup Options Set or selecting an existing one.

TIP: To use an existing set, in the Plugin Options list, select the set that you want to use.
1
Next to the Plugin Options list, click Create New.
2
In the Sybase Backup Type section of the Options tab, select the type of backup to perform:
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.
4
In the Create New Set dialog box, specify a name for the set, and click Save.
Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación