Posted January 4, 20232 yr Our customer got the following errror message "The operation cannot be performed since the database 'digordercontrol-db-test' is in a replication relationship. (Microsoft SQL Server, Error: 40680)" trying to rename a database. Our customer got the following error message using SQL Server Management Studio trying to rename a database. TITLE: Microsoft SQL Server Management Studio ------------------------------ Unable to rename XXX. (ObjectExplorer) ------------------------------ ADDITIONAL INFORMATION: Rename failed for Database 'XXX'. (Microsoft.SqlServer.Smo) For help, click: Microsoft – Cloud, Computers, Apps & Gaming ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The operation cannot be performed since the database 'XXX' is in a replication relationship. (Microsoft SQL Server, Error: 40680) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-40680-database-engine-error Solution This error ocurred when the database is configured in an active geo replication relationship and a failover group. To fix this problem it is needed to remove the database from the active geo replication and failover group to be able to rename the database. Tutorial: Geo-replication & failover in portal - Azure SQL Database | Microsoft Learn Auto-failover groups overview & best practices - Azure SQL Database | Microsoft Learn Rename a Database - SQL Server | Microsoft Learn Enjoy! Continue reading...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.