Remove SQL 2012 Availability Group

Question

Hi,

I have an availability group running on server A to server B with synchronous commit mode. Now, I want to completely remove the AG before I upgrade from SQL 2005 to server A on cutover night.

what are correct steps to remove this availability group on primary? Do I need to remove databases from AG first before I drop the AG?

FYI...our maintenane window is not big enough to do both upgrade and re-setup AG on one night. So, I will wait for next maintenance window to setup AG again.

Thanks much...

Answer 1

AlwaysOn Avalilability Groups are a new feature of SQL Server 2012, yet you mention an upgrade from SQL 2005.  So please clarify your request.

David

---

David http://blogs.msdn.com/b/dbrowne/

Answer 2

SQL 2005 to SQL 2012 upgrade is just normall database engine upgrade by backup and restore. After successfully upgrade to sql 2012 then I will setup availability group.

Answer 3

So do you have a question?

David

---

David http://blogs.msdn.com/b/dbrowne/

Answer 4

refer below to drop/delete AG

http://msdn.microsoft.com/en-us/library/ff878113.aspx

Answer 5

Hi KongDBA,

High Availability groups concept is introduced in SQl2012. I am sure you knew that.

I guess you already have a SQL2012 server and have an availability group.

Now you wanted to migrate some databases from SQL2005 to SQL2012 then add these databases to those availability groups? Is this what you looking for?

If that is true, you do not have to drop the existing group. Simply migrate the databases to your SQL2012 and add to the existing group.

Well if you wanted to create a new group, you can do that.

If your answer is no. Then you need to explain more.

cheers

kumar