January 5, 2023 at 8:39 am
Hi,
We have a primary and secondary server where 'Always on' is set. We remove one DB from Availability group and the same DB in secondary automatically goes to "Not Synchronizing" and then it changes to "Restoring" mode.
How can i use the DB now in secondary server? What all options we have to use the secondary DB in read/write mode. I can't even take backup of the database. Please help. Thanks in Advance!
Chelladurai
January 5, 2023 at 9:25 am
Firstly why was the database removed from the AOAG?
Where any transactions in flight into the database on the primary which may have not made it to the secondary while the database was being removed from the AG?
Depending on the answer will depend if that database is suitable for use or not?
But to switch the DB out of restoring mode you would use the syntax below
RESTORE LOG <DBName> WITH RECOVERY;
January 5, 2023 at 10:14 am
This one works! Thanks a lot!
Purpose is we want one DB to be in Synch till some time and then we need to detach it in Primary server and start using that DB alone in a secondary server.
While trying this we are unable to use in secondary since it was showing as 'restoring'. After applying the above command it works. Thanks for your help!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply