Export (0) Print
Expand All

Log Shipping Monitor Settings

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft