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 Understanding Log Shipping.

To configure log shipping by using SQL Server Management Studio

To view the log shipping report

Options

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

See Also

Other Resources

Monitoring Log Shipping

Help and Information

Getting SQL Server 2005 Assistance