November 14, 2017 at 9:46 pm
Hi,
We have the production database setup in an availability group which can fail over to any of the 4 instances.
We also have a monitoring/DBA database, which has some stats and monitoring SPs.
We need to be able to fail it over to the same instance as the production database. The only concern is, we don't want to impact the fail over of the production database if something goes wrong with the fail over of the monitoring database.
So between two optoins:
1. Put them both into the same availability group and fail them over together
2. Put them into separate availability groups and have some jobs to watch where the production database is and fail over the monitoring database accordingly.
Which one is the best?
Thanks.
November 15, 2017 at 7:14 am
the answer is in your own question, "we don't want to impact the fail over of the production database if something goes wrong with the fail over of the monitoring database." , go with option 1
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply