When attempting to demote the Publisher to Standalone in the Active Roles Console, the following error message is produced:
*Note: The process described below will remove replication from all Active Roles databases. It is strongly advised to back up your SQL databases as well as the SQL server before performing this operation.
Run the SQL stored procedure sp_removebreplication against all Active Roles databases participating in replication, including both the Configuration and Management History databases, for all publishers and subscribers.
example:
Use [Database Name]
EXEC sp_removedbreplication
go
Once completed against all Active Roles databases, all servers will be in a standalone mode. You can now promote the publisher and re-add subscribers if desired.
© 2025 One Identity LLC. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center