Hi All,
Facing a problem where a databases on a sql instance was used in replication now this server has been tuned into a DR so the database is now read only.
Getting flooded with errors from the distribution agent that it cannot update the db because it is in read only. This makes sense.
I want to remove the distribution and publishing from this instance but it will not let me due to the read only state of the user db
(Msg 14166, Level 11, State 1, Procedure sp_replicationdboption, Line 202
Disable publishing ignored error msg 3906, severity 16, state 2: Failed to update database "dbname" because the database is read-only)
I have tried manually doing with with exec sp_dropdistributor @no_checks = 1 but no go.
any help appreciated.