Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Questions


SQL Questions

Author
Message
Austin_123
Austin_123
SSC-Addicted
SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)SSC-Addicted (489 reputation)

Group: General Forum Members
Points: 489 Visits: 454
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
rajborntodare
rajborntodare
SSC-Enthusiastic
SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)SSC-Enthusiastic (111 reputation)

Group: General Forum Members
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 Hehe
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36359 Visits: 18758
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
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search