How to switch from immediate updating to queued updating as a failover (Transact-SQL)

How to Install SQL Server 2000

previous page next page
How To

How to switch from immediate updating to queued updating as a failover (Transact-SQL)

  • Use the sp_setreplfailovermode stored procedure and set the following parameters.
    ParameterDescription
    @publisherName of the Publisher.
    @publisher_dbName of the publication database.
    @publicationName of the publication.
    @failover_modeCan be 'immediate', or 'queued'.

previous page start next page