Log shipping: network share

Log shipping > Specify databases > Backup settings > Restore settings > Network share > Schedule > Review summary

This topic describes the Log Shipping wizard page for specifying the network share to which the transaction log backups will be copied.

When SQL Backup has backed up the source database, the backup file is copied to a folder that can be accessed by the destination SQL Server. The SQL Backup Agent service on both the source and destination SQL Servers must have access to this folder. For more information, see Backing up and restoring on a network share. For details about setting up permissions to use a network share, see Security model.

Type the name of the network share to which you want to copy the backup files, or click and specify the network share using the folder browser. For information about how to specify file names on remote servers, see Specifying file paths. Note: the network share must not be the same location as the folder the processed transaction log backup files are moved to (see step 3).

If you typed the network share name, click Test to check that the user for the SQL Backup Service user on the source SQL Server has permissions to create files on the network share, and that the SQL Backup Service user on the specified destination SQL Server has permissions to access the network share and delete files. If the user for either SQL Backup Service does not have the appropriate permissions, an error message is displayed. If you browsed to the network share, this check is performed automatically.

Optimization

The Network resilience settings control retry behaviour following a read/write error whenever SQL Backup:

• writes a backup file to disk
• copies a backup file to another location

Read/write errors are most likely to occur when SQL Backup is processing files through a network connection.

The Network resilience settings apply to all read/write operations involving the transaction log backups. In most circumstances, you can leave On failure, retry after and Retry up to (n) times at their default values (30 seconds, and 10 times).

To disable retries completely, specify Retry up to 0 times.

Next: set the schedule