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.

 

The server name field is used to specify the fully qualified name of the SQL Server instance to which you wish to connect. This field can be a computer host name, or a combination of host and instance name.

 

Example server names:

 

•(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".

 

Clicking the drop-down arrow associated with the server name field will cause SQL Backup Master to build a listing of any SQL Server instances it can find on the local machine and/or network. Note remote SQL Server instances need to have the SQL Server Browser feature installed and enabled in order to be discovered in this manner.

 

You can also specify logon information for the selected SQL Server instance. The following options are available:

 

•Windows authentication - Choose this option to authenticate to SQL Server using the Windows account specified in your backup job settings.

•SQL Server authentication - Use this method if you have SQL Server Authentication enabled on the selected SQL Server instance and wish to specify a username and password to log on.

 

Use the Test SQL Connection button to ensure proper connectivity, and then click the OK button to proceed.

 

Connection Options

 

The following options are available when configuring your SQL Server connection.

 

•Encrypt connection - Forces encryption of the connection to SQL Server.

•Trust server certificate - Encryption will use a self-signed server certificate without validation if no verifiable certificate has been provisioned on the server

 

Note that not all versions of SQL Server support the above options. Please see your SQL Server product documentation 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 Backup all non-system 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 Backup all non-system databases option, you can also exclude one or more databases if needed.

 

To do so, click the Apply exclusions check box 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".