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.
In the main SQL Backup Master window, select the Backup and restore tab, then click the 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.
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".
Note: If you choose to connect to SQL Server using Windows Authentication, then you should also configure your backup job to run using a specific Windows account.
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.
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.
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:
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.
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.
Congratulations. You've now successfully created and executed a database backup job using SQL Backup Master. Other common steps include: