18 Backup / Restore Microsoft SQL Server

This section describes how to backup and restore Microsoft SQL Server with the OBM.

The following steps are performed during a backup job:

Connection from the backup client to the backup server is established.
Download the server file list from the backup server.
Connection to the SQL server is established.
Commands are issued for the database or transaction log backup files to be spooled to the temporary spool path.
Server and local file lists are compared to determine which file will be uploaded.
Delta file is generated for modified file (if necessary).
Data are encrypted, compressed, and uploaded to the backup server.
Data are removed from the temporary spool path.
Backup completed successfully.