MSSQL_ENG014120

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Message Details

Product Name SQL Server
Event ID 14120
Event Source MSSQLSERVER
Component SQL Server Database Engine
Symbolic Name
Message Text Could not drop the distribution database '%s'. This distributor database is associated with a Publisher.

Explanation

The distribution database stores metadata and history data for all types of replication and transactions for transactional replication. This error occurs if you attempt to drop a distribution database that is associated with one or more Publishers.

User Action

To drop a distribution database you must first drop the association between the Distributor and the Publisher. For more information, see sp_dropdistpublisher (Transact-SQL).

See Also

Errors and Events Reference (Replication)
Configure Distribution