Lesson Learned #267: Rename failed for Database 'XXX' in Azure SQL Database

[Guest Jose_Manuel_Jurado]

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...