July 22, 2013 at 5:29 am
Hello SQL Experts,
In my current support environment I am reviewing all SOP and OLA's for the SQL.
Below are the few questions which I am seeking for an expert advice.
1) While failing over the cluster should we pause\suspend the database mirror?
2) What should be the best practice while handling database mirror and log shipping while working on Production and DR scenarios.
Please let me know if we have any links\ or already have the answers for above queries.
Thanks in advance.
Regards,
Austin
July 22, 2013 at 8:36 am
failing over the cluster should we pause\suspend the database mirror?
Hi Austin,
Just adding a word, i know it's not answering your question..
Why dont you enable Always On High Availability feature instead of using mirroring (It is about to be discontinued from next SQL version may be from sql 2014) or log shipping...
If you are using SQL 2012.. YOu can use this Always On feature..
Rookie here :hehe:
July 22, 2013 at 9:22 am
AlwaysOn isn't just a 2012 feature, it's an Enterprise 2012 feature, so that can be a consideration.
You haven't really defined the problem, Austin, and we can't see your environment, so it's hard to tell what you mean.
Re #1, do you mean you have a cluster and use DBM to an instance not on your cluster? If so, you do nothing. The cluster fails over. DBM will pick up when the cluster starts on the new node. It's like a reboot. In that case, you don't do anything to pause mirroring.
Re: #2 - What is "handling" and what is "working on"?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply