Allows you to set the failover operation mode for subscriptions enabled for immediate updating with queued updating as failover. This stored procedure is executed at the Subscriber on the subscription database. For more information about failover modes, see Updatable Subscriptions for Transactional Replication.
sp_setreplfailovermode [ @publisher= ] 'publisher' [ , [ @publisher_db = ] 'publisher_db' ] [ , [ @publication= ] 'publication' ] [ , [ @failover_mode= ] 'failover_mode' ] [ , [ @override = ] override ]
- [ @publisher=] 'publisher'
Is the name of the publication. publication is sysname, with no default. The publication must already exist.
- [ @publisher_db =] 'publisher_db'
Is the name of the publication database. publisher_db is sysname, with no default.
- [ @publication=] 'publication'
Is the name of the publication. publication is sysname, with no default.
- [@failover_mode =] 'failover_mode'
Is the failover mode for the subscription. failover_mode is nvarchar(10) and can be one of these values.
immediate or sync
Data modifications made at the Subscriber are bulk-copied to the Publisher as they occur.
Data modifications are stored in a Microsoft SQL Server queue.
Note: Microsoft Message Queuing has been deprecated and is no longer supported.
- [ @override= ] override
Internal use only.