Resumes a suspended Distributor thread for a connection to a database.s
resume distributor data_server.database [skip transaction]
The data server name. If the database is part of a warm standby application, data_server is the logical data server name.
The database name. If the database is part of a warm standby application, database is the logical database name.
Instructs Replication Server to resume execution with the second transaction in the connection’s queue. The first transaction is written to the database exceptions log.
Resumes the Distributor thread for the logical data server LDS and the pubs2 database:
resume distributor LDS.pubs2
Use resume distributor to resume a Distributor thread suspended using suspend distributor or suspended by Replication Server.
Use skip transaction to resume connection when distributor is down due to:
message in inbound queue is longer than 16,000 bytes and site version has not been upgraded to RS 12.5 and up, or
downstream Replication Server cannot accept new feature commands, for example, bigint.
resume distributor requires “sa” permission.
