MSSQL_ENG014121
Applies to: SQL Server Azure SQL Managed Instance
Message Details
Attribute | Value |
---|---|
Product Name | SQL Server |
Event ID | 14121 |
Event Source | MSSQLSERVER |
Component | SQL Server Database Engine |
Symbolic Name | |
Message Text | Could not drop the Distributor '%s'. This Distributor has associated distribution databases. |
Explanation
A SQL Server instance that is configured as a Distributor cannot be removed from the role of Distributor because there are distribution databases associated with the instance. This error occurs if you attempt to drop a distribution database that is associated with one or more Publishers.
User Action
To find the names of any Publishers and distribution databases associated with this Distributor, execute sp_helpdistpublisher (Transact-SQL) from any database on the Distributor.
Execute sp_dropdistributiondb (Transact-SQL) for any distribution databases associated with this Distributor. After all distribution database associations are removed, you can disable distribution.
See Also
Errors and Events Reference (Replication)
Configure Distribution
Зворотний зв’язок
https://aka.ms/ContentUserFeedback.
Очікується незабаром: протягом 2024 року ми будемо припиняти використання механізму реєстрації проблем у GitHub для зворотного зв’язку щодо вмісту й замінювати його новою системою зворотного зв’язку. Докладніше:Надіслати й переглянути відгук про