sys.sp_replrestart

Description

Used by transactional replication during backup and restore so that the replicated data at the Distributor is synchronized with data at the Publisher. This stored procedure is executed at the Publisher on the publication database. is used when the highest log sequence number (LSN) value at the Distributor doesn’t match the highest LSN value at the Publisher. fixed database role can execute

Permissions

06/23/2025 Used by transactional replication during backup and restore so that the replicated data at the Distributor is synchronized with data at the Publisher. This stored procedure is executed at the Publisher on the publication database. syntaxsql None. (success) or (failure). is used when the highest log sequence number (LSN) value at the Distributor doesn’t match the highest LSN value at the Publisher. Only members of the fixed server role or fixed database role can execute. ） Important is an internal replication stored procedure and should only be used when restoring a database published in a transactional replication topology as directed in.

Code Blocks

0

1

sp_replrestart

sp_replrestart
[ ; ]