April 29, 2018 at 5:35 am
Good Morning Experts,
If i delete the Availability Group(AG) in primary replica, what will be the status of databases in primary replica and secondary replica? What will be the status of AG on secondary replica?Also, what would be the status of AG on secondary replicas? Would it be " Resolving" or something else?
April 29, 2018 at 6:05 am
coolchaitu - Sunday, April 29, 2018 5:35 AMGood Morning Experts,
If i delete the Availability Group(AG) in primary replica, what will be the status of databases in primary replica and secondary replica? What will be the status of AG on secondary replica?Also, what would be the status of AG on secondary replicas? Would it be " Resolving" or something else?
Can you please share some more details on the AG setup, i.e. is it a BAG, read only etc.?
😎
April 29, 2018 at 9:04 am
Eirikur Eiriksson - Sunday, April 29, 2018 6:05 AMcoolchaitu - Sunday, April 29, 2018 5:35 AMGood Morning Experts,
If i delete the Availability Group(AG) in primary replica, what will be the status of databases in primary replica and secondary replica? What will be the status of AG on secondary replica?Also, what would be the status of AG on secondary replicas? Would it be " Resolving" or something else?
Can you please share some more details on the AG setup, i.e. is it a BAG, read only etc.?
😎
It is a readable secondary replica
April 30, 2018 at 2:52 am
The best thing you can do is just install Developer Edition in a test environment and try it.
April 30, 2018 at 10:30 am
Beatrix Kiddo - Monday, April 30, 2018 2:52 AMThe best thing you can do is just install Developer Edition in a test environment and try it.
Thanks for the reply Kiddo. Unfortunately, I do not have a machine and test environment. Could you please try and let me know
May 1, 2018 at 3:31 am
Er, no, sorry. You need a dev environment.
May 2, 2018 at 4:37 am
Eirikur Eiriksson - Sunday, April 29, 2018 6:05 AMcoolchaitu - Sunday, April 29, 2018 5:35 AMGood Morning Experts,
If i delete the Availability Group(AG) in primary replica, what will be the status of databases in primary replica and secondary replica? What will be the status of AG on secondary replica?Also, what would be the status of AG on secondary replicas? Would it be " Resolving" or something else?
Can you please share some more details on the AG setup, i.e. is it a BAG, read only etc.?
😎
I got the answer. I am surprised how SSC has classified you as a GURU despite not knowing this simple concepts.
May 3, 2018 at 4:55 am
coolchaitu - Sunday, April 29, 2018 5:35 AMGood Morning Experts,
If i delete the Availability Group(AG) in primary replica, what will be the status of databases in primary replica and secondary replica? What will be the status of AG on secondary replica?Also, what would be the status of AG on secondary replicas? Would it be " Resolving" or something else?
you going for an interview by any chance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 3, 2018 at 5:41 am
Perry Whittle - Thursday, May 3, 2018 4:55 AMcoolchaitu - Sunday, April 29, 2018 5:35 AMGood Morning Experts,
If i delete the Availability Group(AG) in primary replica, what will be the status of databases in primary replica and secondary replica? What will be the status of AG on secondary replica?Also, what would be the status of AG on secondary replicas? Would it be " Resolving" or something else?
you going for an interview by any chance
no Perry. I am curious to know. Its my curiousity that brings out questions.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply