Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 8:11 AM
Points: 448, Visits: 406
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
Post #1475952
Posted Monday, July 22, 2013 8:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:00 PM
Points: 33,204, Visits: 15,354
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