How to make data backup of ASA in PB

First, full and incremental backups

Full backup backs up both the database file and the transaction log. Incremental backup only backs up the transaction log. Typically, multiple incremental backups are interspersed during a full backup. For example, make a full backup once a week and make an incremental backup every day.

Second, perform a full backup or incremental backup

A full backup is a backup of the database files and transaction log files. An incremental backup backs up only the transaction log files. Typically, you should make several incremental backups between full backups every two times.

1. Make sure that you have DBA authority on the database.

2. Perform a checksum check on the database to make sure it is not corrupted. You can use the validation utility or the sa_validate stored procedure.

For example, connect to the database as a DBA, and then run the command:

Call Sa_validate

Or at the command line:

Dbvalid-c "Connection string"

3. Back up database files and/or logs. (depending on whether a full or incremental backup)

Here are three backup modes, respectively:

A. Perform a backup and continue using the original transaction log.

This task describes the simplest type of backup-the transaction log is not touched.

Sybase mode:

1. Start Sybase. Connect to the database as a user with DBA authority.

2. Right-click the database and choose Create Backup image from the pop-up menu. At this point, the Create Backup Image Wizard appears.

3. On the introduction page of the wizard, click Next.

4. Select the database you want to back up.

5. On the next page, enter the name of the directory where you want to save the backup copy, and then choose whether to perform a full backup (back up all the database files) or an incremental backup (only the transaction log files are backed up).

6. On the next page, select the continue to use the same transaction log option.

7. Click Finish to start the backup.

SQL statement Method:

1. If you want to use the BACKUP statement, use only the following clauses:

BACKUP DATABASE

DIRECTORY Directory_name

[TRANSACTION LOG only]

If you want to perform an incremental backup, include the TRANSACTION LOG only clause.

Command-line method:

1. If you want to use the Dbbackup utility, use the following syntax:

Dbbackup-c "Connection_string" [-t] backup_directory

The-t option is included only when an incremental backup is performed.

B. Performing a backup, deleting the original transaction log

If replication does not involve your database, and you have limited disk space on your online computer, you can delete the contents of the online transaction log (the truncate log) when you perform a backup. In this case, you will need to use every backup copy that has been created since the last full backup in the process of recovering from a media failure in the database file.