December 16, 2014 at 11:19 pm
We have a production setup having SQL SERVER 2012 always on configured.
for easy understanding Server 1 has 2 databases in AG group.
and server 2 has 2 databases in AG group.
one of the database on secondary server 2 is down i mean its not in synchronization state.
now, when we tried to remove the database in secondary server 2 AG group it thrown error and we
dropped the database from actual databases. But, AG still shows the database in red mark.
WE Were able to drop successfully. but, in AG we still see the database listed. we are not able to remove it. when we try to remove it tell database does not exists.
can some one help us. how to remove the database from AG group.? Any script.
our plan was to take fresh backup from primary and restore to secondary server
and then take the transaction log backup and apply to secondary server and
then add in AG?
December 17, 2014 at 4:20 am
you didnt use the "Remove secondary database" option then?
Haver you tried this on the secondary where the database was deleted from?
ALTER DATABASE thedb SET HADR OFF
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2014 at 2:44 pm
Yes we tried and we got error when used that command which you provided.
Redo log ERROR.
Then we decided to remove the database from User databases.
Thought it would remove from AG too.
But, it did not happen.
we still that database under AG. not able remove,
when try to remove it it shows error the database does not exists.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply