Procedimentos armazenados de envio de logs (Transact-SQL)

O SQL Server 2005 e versões posteriores dão suporte aos procedimentos armazenados do sistema a seguir que são usados para configurar, modificar e monitorar configurações de envio de logs.

sp_add_log_shipping_alert_job	sp_delete_log_shipping_secondary_database
sp_add_log_shipping_primary_database	sp_delete_log_shipping_secondary_primary
sp_add_log_shipping_primary_secondary	sp_help_log_shipping_alert_job
sp_add_log_shipping_secondary_database	sp_help_log_shipping_monitor
sp_add_log_shipping_secondary_primary	sp_help_log_shipping_monitor_primary
sp_change_log_shipping_primary_database	sp_help_log_shipping_monitor_secondary
sp_change_log_shipping_secondary_database	sp_help_log_shipping_primary_database
sp_change_log_shipping_secondary_primary	sp_help_log_shipping_primary_secondary
sp_cleanup_log_shipping_history	sp_help_log_shipping_secondary_database
sp_delete_log_shipping_alert_job	sp_help_log_shipping_secondary_primary
sp_delete_log_shipping_primary_database	sp_refresh_log_shipping_monitor
sp_delete_log_shipping_primary_secondary

Consulte também

Referência

Procedimentos armazenados do sistema (Transact-SQL)

Outros recursos

Administração de envio de logs