Edit

MSSQL_REPL-2147199376

  • Article

Applies to: SQL Server Azure SQL Managed Instance

Message Details

Attribute Value
Product Name SQL Server
Event ID -2147199376
Event Source MSSQLServer
Symbolic Name
Message Text One or more articles in the publication are configured to have non-overlapping partitions that are unique for each subscription, and there is already another subscription with the same partition. Drop any unused subscription registrations for this partition or change the partitioning options for the article.

Explanation

When a publication contains one or more articles that were configured by using partition_options=3, the merge process checks to make sure that there is only one subscription per partition.

User Action

If the publication contains stale subscriptions, drop these subscriptions by using sp_dropmergesubscription.

Internal-Only