Log Shipping Monitor Settings

 

Applies To: SQL Server 2016

Use this page to configure and to modify the properties of the log shipping monitor server.

For an explanation of log shipping concepts, see About Log Shipping (SQL Server).

Monitor server instance
Displays the name of the server instance that is currently configured as the monitor server for the log shipping configuration.

Connect
Choose and connect to an instance of SQL Server to be used as the monitor server. The account used to connect must be a member of the sysadmin fixed server role on the secondary server instance.

By impersonating the proxy account of the job
Have log shipping impersonate the SQL Server Agent proxy account when connecting to the monitor server instance. The backup, copy, and restore processes must be able to connect to the monitor server to update the status of log shipping operations.

Using the following SQL Server login
Allow log shipping to use a specific SQL Server login when connecting to the monitor server instance. The backup, copy, and restore processes must be able to connect to the monitor server to update the status of log shipping operations. Choose this option if you want log shipping to use a specific SQL Server login and then specify the login and password.

Delete history after
Specify the amount of time to retain log shipping history information on the monitor server before it is deleted.

Job name
Indicates the name of the SQL Server Agent alert job used by log shipping to raise alerts when backup or restore thresholds have been exceeded. When first creating this job, you can change the name by typing in the box.

Schedule
Indicates the current schedule of the SQL Server Agent alert job.

Edit
Modify the SQL Server Agent alert job parameters.

Disable this job
Suspend the SQL Server Agent alert job.

Community Additions

ADD
Show: