Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Questions Expand / Collapse
Posted Monday, July 22, 2013 5:29 AM



Group: General Forum Members
Last Login: Tuesday, September 13, 2016 6:57 AM
Points: 487, Visits: 447
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.

Post #1475952
Posted Monday, July 22, 2013 8:36 AM


Group: General Forum Members
Last Login: Tuesday, January 5, 2016 12:25 PM
Points: 111, Visits: 510
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
Post #1476039
Posted Monday, July 22, 2013 9:22 AM



Group: Administrators
Last Login: Yesterday @ 8:38 AM
Points: 34,366, Visits: 18,586
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"?

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1476075
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse