SQL Server Protection

SQL Server backups should be created using System Protection bare-metal backups, which can be used to restore SQL databases or recover the full SQL Server. You can use Cloud Backup, File Protection and File Archiving, but they do not provide an SQL Server recovery option.

SQL Server Protection is a dedicated SQL backup type in the Jobs tab. It uses the SQL Continuous add-on to backup local and remote SQL Servers. The local backups can be used for point-in-time database restores and full SQL Server restores.

This guide explains how to create an SQL Server Protection backup job.

How to create an SQL Protection backup job

Launch BackupAssist and follow the steps outlined below:

  1. Select the Jobs tab.
  2. Select Home.
  3. Select Create a New Backup Job.
  4. Select SQL Server Protection.
  5. If this is the first time you have created an SQL Server Protection job or if your current backup user identify is the local system logon, you will be asked to provide a Backup User Identity. To learn more, see Backup user identity

  6. Selections.
    The selections screen is used to locate your SQL servers, authenticate them and select the databases to be backed up. BackupAssist will scan your local machine for SQL servers, and any servers found will be selectable from a drop-down list.
  7. Destination media.
    You will not be prompted to provide a destination. This step will be skipped. SQL Server Protection backups are saved to a local drive on the SQL Server. The path used will be set to a default, and can be updated at the, Set up Destination step.
  8. Schedule.
    There are two schedules available for SQL Server Protection: Basic, which provides a daily backup of the SQL Server, and Transactional, which runs transaction backups through the day for point-in-time restores.
  9. Set up destination.
    SQL Server Protection backs up to the local drive, and a default local path will be provided for this step. You can change this path to another location on the SQL Server’s local drive.
  10. Notifications
    Once a backup job has completed, BackupAssist can send an email to inform selected recipients of the result. This email notification is enabled during the creation of the backup job, but you must also provide your mail server settings so that the notifications can be sent. To learn how to configure your mail server for BackupAssist, see Email server settings.
  11. Prepare media.
    SQL Server Protection backups use fixed media only. Media preparation applies to removable media only, therefore this step will be skipped.
  12. Name your backup.
    Provide a name for your backup job, and click Finish.

Your SQL Server Protection backup job has now been created.

Note: BackupAssist's reports can be used to review the results of each backup job. Backups should also so be checked by performing a test restore. Regular test restores should be part of your backup solution.

Warning: If a server or operating system is damaged, you may want to perform a recovery. A system recovery requires a bare-metal image backup. For this reason, you should consider scheduling an System Protection backup of your SQL Server as part of your backup plan. For example, you run a Transactional backup though the day and a System Protection backup each night.

What's next