sp_upgrade_log_shipping (Transact-SQL)

sp_upgrade_log_shipping (Transact-SQL)


Applies To: SQL Server 2014, SQL Server 2016 Preview

The sp_upgrade_log_shipping stored procedure is invoked automatically for upgrading metadata that is specific to log shipping.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions


0 (success) or 1 (otherwise)

This stored procedure is invoked automatically during SQL Server upgrade for upgrading metadata for log shipping. You do not need to execute this procedure explicitly, unless a problem occurs with the metadata during upgrade.

sp_upgrade_log_shipping must be run from the master database on the primary, secondary, or monitor server.

Requires membership in the sysadmin fixed server role.

Community Additions

© 2015 Microsoft