sp_add_log_shipping_secondary_database |
Ajout d'une base de données secondaire d'expédition |
|---|---|
| SQL Server | |
Syntaxe
|
sp_add_log_shipping_secondary_database [ @secondary_database = ] 'secondary_database', [ @primary_server = ] 'primary_server', [ @primary_database = ] 'primary_database', [, [ @restore_delay = ] 'restore_delay'] [, [ @restore_all = ] 'restore_all'] [, [ @restore_mode = ] 'restore_mode'] [, [ @disconnect_users = ] 'disconnect_users'] [, [ @block_size = ] 'block_size'] [, [ @buffer_count = ] 'buffer_count'] [, [ @max_transfer_size = ] 'max_transfer_size'] [, [ @restore_threshold = ] 'restore_threshold'] [, [ @threshold_alert = ] 'threshold_alert'] [, [ @threshold_alert_enabled = ] 'threshold_alert_enabled'] [, [ @history_retention_period = ] 'history_retention_period'] |
Description
Cette Stored Procedure permet de configurer une base de données secondaire pour l'envoi des journaux.
Dernière mise à jour : Dimanche, le 29 Août 2021