?
Solved

Sharepoint 2010 SQL 2008 R2 Mirroring over WAN link

Posted on 2011-03-23
4
Medium Priority
?
823 Views
Last Modified: 2012-06-21
Has anyone experience of Sharepoint 2010 SQL 2008 R2 database mirroring over a WAN link ? I know the supported scenarios, our WAN link will be average anything from about 2ms-20ms round trip, and there will be a limited number of low-usage, smallish (less than 20GB) databases and ideally, would like to do High-Availability with automatic failover, but probably more realistically, to avoid spurious failovers due to loss of connection to witness, High Availability with manual failover. It is essentially for business continuance in the event that a WAN link goes down, or that we lose the SQL server in the primary site. We would also like to be able to use full failover and run completely from the other site (will install another WFE server in DR site for this).
So really looking for experiences, advice etc.

Thank you
0
Comment
Question by:TheGeezer2010
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:sharepointguru14
ID: 35204050
I would say if you were 10ms or less than you wouldn't have any issues at all. Although then clustering would work as well. 20ms and small transactional data to be replicated I think you should be fine.

you issue will be if you lose the wan link for any extended period of time and replicating the backlog.
0
 
LVL 11

Author Comment

by:TheGeezer2010
ID: 35205535
Hi Sharepointguru14

Have you actually tried this yourself ? Regarding the backlog, if we were to lose the link a judgement call would need to be made on whether to suspend or stop the mirroring depending on likely time to fix.

The plan now is to get this up and running in synchronous - no auto failover mode, test full failover on the SQL back-end, if this works OK, will then introduce a WFE in DR site and try failover using the new FE. I am not sure however if you can span a WFE over different AD sites - suspect not, so this would have to be a DNS change to effect this failover - and hence some delay.

I have one lother question - if I then include all of the databases which CAN be mirrored (all content, service (with the exceptions shown in Microsoft documentation e.g. SyncDB), config), if the link goes down when all is synced and we failover, is there anything else which needs to be done in terms of backing up/restoring other databases etc, and indeed, if the link goes down are you actually ABLE to failover ?

Sorry for questions but this whole topic seems to get more confusing the deeper you delve !!
0
 
LVL 15

Accepted Solution

by:
sharepointguru14 earned 1200 total points
ID: 35207101
mirroring I have not done myself. Typically I have implemented clustered backend and then you either SAN replication or Log shipping for the DR solution. I'm not a huge fan of mirroring in the same datacenter so I'm not going to tell you I like the idea over a wan. The good news is...it really doesn't take much to setup and test. I don't know what your links are and actually how much you are going to be mirroring to tell you whether or not it is going to work. Really you need to just set it up and test it. If its not much change and less than 20ms I expect that it will work but I wouldn't count on it being a completely seamless or automatic solution but it would be a viable DR strategy.
0
 
LVL 11

Author Comment

by:TheGeezer2010
ID: 35256488
Hi SPG and thanks for your input

Can you describe how your DR solution works as we also would have the possibility of using SAN replication + log shipping. The issue I have with log shipping is that you cannot use it for any service or config databases.

Am I right then that this will only be a useful DR solution if the server/database fails. If the link fails we will have to break mirroring and maybe lose small amount of data.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn how the use of a bunch of disparate tools requiring a lot of manual attention led to a series of unfortunate backup events for one company.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
In this Micro Tutorial viewers will learn how to restore single file or folder from Bare Metal backup image of their system. Tutorial shows how to restore files and folders from system backup. Often it is not needed to restore entire system when onl…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question