SQL Backup Master Help

Use the Source section of the Database Backup Editor window to designate which SQL Server database(s) will be backed up.

 

Choosing a SQL Server Instance

 

Click the Choose SQL Server button to show the Connect to SQL Server window.

 

See the Connecting to SQL Server help topic for details.

 

Selecting Databases to Back Up

 

Once you've specified a SQL Server connection, SQL Backup Master will enumerate and list its associated databases.

 

You can either either place a check mark next to the databases you wish to back up, or click the All user databases option to ensure that all non-system databases are backed up (even if they are added at a later date).

 

Showing System Databases

 

If you'd like SQL Server system databases to appear in the database listing, click the Show system databases check box. Once done, you can select the system databases you wish to be included in the current backup.

 

Note that the SQL Server "tempdb" and "resource" system databases are never shown in SQL Backup Master, because it is not necessary (nor is it even possible) to back them up.

 

Exclusions

 

When using the All user databases option, you can also exclude one or more databases if needed.

 

To do so, check the Apply exclusions checkbox and then click the associated hyperlink. The Database Exclusions editor will appear. Here, you can add as many exclusionary patterns as you need. Wildcard characters may also be used. For example, the pattern "test*" (without the quotes) will exclude any database that starts with "test".