This topic has not yet been rated - Rate this topic

sp_validate_replica_hosts_as_publishers (Transact-SQL)

SQL Server 2012

sp_validate_replica_hosts_as_publisher is an extension of sp_validate_redirected_publisher that allows all secondary replicas to be validated, rather than just the current primary replica. sp_validate_replicat_hosts_as_publisher validates an entire AlwaysOn replication topology. Must be run from a distribution database.

Topic link icon Transact-SQL Syntax Conventions

Syntax


          

sp_validate_replica_hosts_as_publisher 
    [ @original_publisher = ] 'original_publisher',
    [ @publisher_db = ] 'database_name', 
    [ @redirected_publisher = ] 'new_publisher' output

Arguments

[ @original_publisher = ] 'original_publisher': The name of the instance of SQL Server that originally published the database. original_publisher is sysname, with no default.
[ @publisher_db = ] 'publisher_db': The name of the database being published. publisher_db is sysname, with no default.
[ @redirected_publisher = ] 'redirected_publisher': The target of redirection when sp_redirect_publisher was called for the original publisher/published database pair. redirected_publisher is sysname, with no default.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None.

Remarks

If no entry exists for the publisher and the publishing database, sp_validate_redirected_publisher returns null for the output parameter @redirected_publisher. Otherwise, the associated redirected publisher is returned, both on success and failure.

If the validation succeeds, sp_validate_redirected_publisher returns a success indication.

If the validation fails, appropriate errors are raised. sp_validate_redirected_publisher makes a best effort to raise all issues and not just the first encountered.

Permissions

Caller must either be a member of the sysadmin fixed server role, the db_owner fixed database role for the distribution database, or a member of a publication access list for a defined publication associated with the publisher database.

Reference

Replication Stored Procedures (Transact-SQL)

sp_get_redirected_publisher (Transact-SQL)

sp_redirect_publisher (Transact-SQL)

sp_validate_redirected_publisher (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD