Section courante

A propos

Section administrative du site

sp_change_log_shipping_primary_database

Change la base de données primaire
SQL Server

Syntaxe

sp_change_log_shipping_primary_database [ @database = ] 'database'
[, [ @backup_directory = ] 'backup_directory']
[, [ @backup_share = ] 'backup_share']
[, [ @backup_retention_period = ] 'backup_retention_period']
[, [ @monitor_server_security_mode = ] 'monitor_server_security_mode']
[, [ @monitor_server_login = ] 'monitor_server_login']
[, [ @monitor_server_password = ] 'monitor_server_password']
[, [ @backup_threshold = ] 'backup_threshold']
[, [ @threshold_alert = ] 'threshold_alert']
[, [ @threshold_alert_enabled = ] 'threshold_alert_enabled']
[, [ @history_retention_period = ] 'history_retention_period']
[, [ @backup_compression = ] backup_compression_option ]

Description

Cette Stored Procedure permet de modifier les paramètres de la base de données principale.



Dernière mise à jour : Dimanche, le 29 Août 2021