SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

System Tables (Transact-SQL)

Log Shipping Tables (Transact-SQL)

log_shipping_monitor_alert (Transact-SQL)

log_shipping_monitor_error_detail (Transact-SQL)

log_shipping_monitor_history_detail (Transact-SQL)

log_shipping_monitor_primary (Transact-SQL)

log_shipping_monitor_secondary (Transact-SQL)

log_shipping_primary_databases (Transact-SQL)

log_shipping_primary_secondaries (Transact-SQL)

log_shipping_secondary (Transact-SQL)

log_shipping_secondary_databases (Transact-SQL)

Minimize

This topic has not yet been rated - Rate this topic

log_shipping_monitor_alert (Transact-SQL)

SQL Server 2012

Stores the alert job ID for log shipping. This table is stored in the msdb database.

Column name	Data type	Description
alert_job_id	uniqueidentifier	The SQL Server Agent job ID of the log shipping alert job.

Reference

sp_add_log_shipping_alert_job (Transact-SQL)

sp_delete_log_shipping_alert_job (Transact-SQL)

sp_help_log_shipping_alert_job (Transact-SQL)

System Tables (Transact-SQL)

Concepts

About Log Shipping (SQL Server)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.