Solved

Sharepoint 2010 SQL 2008 R2 Mirroring over WAN link

Posted on 2011-03-23
4
787 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
  • 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 300 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

First I will try to share a design of a Veeam Backup Infrastructure without Direct NFS Access backup. Note: Direct NFS Access backup transport mechanism is only available in Veeam v9 In above I try to design the Veeam Backup flow between i…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

919 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now