Show/Hide Toolbars

SQL Backup Master Help

Navigation: Getting Started

Tutorial

Scroll Prev Top Next More

This tutorial is designed to help you get up and running with SQL Backup Master.

 

If you haven't already downloaded and installed SQL Backup Master, please do so now. Once installed, start SQL Backup Master via the desktop shortcut or Start menu entry.

 

Step 1 - Create a Backup Job

 

In the main SQL Backup Master window, select the Backup and restore tab, then click the Create new database backup toolbar button.

 

The Database Backup Editor window will appear.

 

Give your backup job a unique name (and, optionally, a description). This will help you to identify it easily in the future.

 

Step 2 - Connect to SQL Server

 

In the Database Backup Editor window, click the Choose SQL Server button. The Connect to SQL Server window will appear.

 

In the Server name field, enter or select the name of the SQL Server instance to which you are connecting. Common examples include:

 

(local)\SQLExpress - Specifies the default SQL Express named instance on the local computer.

(local) - Specifies the local SQL Server installation (without an instance name).

Server1\SQLExpress - Specifies the default SQL Express names instance on a remote computer named "Server1".

Server1 - Specifies an unnamed SQL Server instance on a remote computer named "Server1".

 

You can also use the drop-down arrow of the Server name field to find local and remote SQL Server instances, which you can then select.

 

Test the connection by clicking the Test SQL Connection button, then click OK.

 

Step 3 - Select databases to back up

 

Once you've connected to a SQL Server instance, the Database Backup Editor window will show available databases with checkboxes next to them. Select the databases you wish to back up as part of this job.

 

Or you can click the Back up all non-system databases checkboxes. With this option enabled, new databases created on the target SQL Server in the future will be backed up automatically.

 

Step 4 - Decide where to store database backups

 

Under the Destinations heading in the Database Backup Editor window, click the Add toolbar button.

 

Click the service you'd like to use for storing database backup files, then click the Select button.

 

The configuration (settings) window for the selected destination will appear. To learn more about configuring a specific destination type, please see one of the following help topics:

 

Dropbox

Google Drive

Amazon S3

FTP (including FTPS and SFTP)

Local or network folder

Azure Storage

Box

OneDrive

 

Repeat Step 4 if you'd like to send your database backup files to additional storage destinations.

 

When you're done creating destinations, click the Save button to save the backup job and return to the main window.

 

Step 5 - Run the backup job to test it

 

Back in the main application window, select your newly created backup job and click the Back up now button.

 

If the backup job does not run to successful completion, please review the log file for details.

 

Step 6 - Additional Configuration

 

Congratulations. You've now successfully created and executed a database backup job using SQL Backup Master. Other common steps include:

 

Configure email notifications

Configure scheduling

Configuring backup encryption