SQL Backup Master Help
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 Windows Start menu.
Step 1 - Create a Backup Job
In the main SQL Backup Master window, navigate to the Backups area, then click the New 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 server name 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'll also need to specify a Username and Password to use when connecting with SQL Server, depending on which server logon type you're using:
•Windows authentication - Enter the credentials of the Windows user account you wish to impersonate when connecting to SQL Server. This account will be automatically linked to the Windows Account configuration in your backup job settings.
•SQL Server authentication - Enter the credentials of the SQL Server account you wish to use.
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:
•FTP (including FTPS and SFTP)
•Box
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 Run 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:
