1Backup Agent

Clients of the 1Backup Service are Agents, ie. the softwares that get installed on the machines we want to backup.
Agents are also specialized in the backup of the most popular databases like Microsoft SQL, Oracle Database, MySQL Database

The goal of this document is to provide some useful information about how the 1Backup Agent interacts with such databases during the backup operations.

MICROSOFT SQL DATABASE

A scheme about how a Microsoft SQL database is backed up follows:

Description of the execution phases:

• Backup process starts.
• All the Microsoft SQL Server databases are backed up (with *.bak extension) in a temporary directory.
• All backup data generated in the temporary directory is uploaded to the offsite backup server.
• Backup process ends.

Notes

• Backup can be planned to be executed automatically.
• Databases can be restored from any snapshot of the DB.
• If Incremental Backup is selected, then backup files (*.bak) will be incremental in turn.
• 1Backup must be installed on the server where the Microsoft SQL database resides on.

ORACLE DATABASE

A scheme about how an Oracle database is backed up follows:

Description of the execution phases:

• Backup process starts.
• All [Data Files] in Oracle are backed up to a temporary directory.
• All [Control Files] in Oracle are backed up to a temporary directory.
• All [Archived Log Files] in Oracle are backed up to a temporary directory.
• A copy of [Init File] (PFile) is backed up in a temporary directory.
• All backup data generated in the temporary directory is uploaded to the offsite backup server.
• Backup process ends.

Notes

• Backup can be planned to be executed automatically.
• Databases can be restored from any snapshot of the DB.
• If Incremental Backup is selected, only the new [Archived Log Files] will be copied onto the offsite server.
• The Oracle database and the backup server can be installed on UNIX, Linux or Windows platforms, and the 1Backup Agent can be installed on the same server or on another one.

MySQL DATABASE

A scheme about how a MySQL database is backed up follows:

Description of the execution phases:

• Backup process starts.
• All databases are backed up from MySQL Server to a temporary directory.
• All backup data generated in the temporary directory is uploaded to the offsite backup server.
• Backup process ends.

Notes

• Backup can be planned to be executed automatically.
• 1Backup must be installed on the server where the MySQL database resides on.