Blog Post

Removing a secondary replica database in Always On SQL Environment

,

Removing a database from an Always On availability group is pretty straight forward and can be accomplished by either ssms or script.

To remove a database from a secondary replica after it is removed from the primary replica may result in errors if you are using the ssms.  The script below can be ran on the secondary availability group to remove databases from the AG.

 

ALTER DATABASE ENTER DATABASE NAME SET HADR OFF;  
GO

The post Removing a secondary replica database in Always On SQL Environment appeared first on VitaminDBA.

Rate

Share

Share

Rate