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

DR/HA proposal Expand / Collapse
Author
Message
Posted Monday, March 11, 2013 5:59 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 7, 2013 4:29 PM
Points: 23, Visits: 146
I need to write DR/HA proposal any suggestions?
Post #1429548
Posted Tuesday, March 12, 2013 1:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 8:43 AM
Points: 223, Visits: 1,720
You can start from here http://download.microsoft.com/download/5/B/D/5BD13FFA-5E34-4AE1-9AA0-C6E6951B8FC8/SQL%20Server%202008%20R2%20High%20Availability%20Architecture%20White%20Paper.docx
Post #1429607
Posted Tuesday, March 12, 2013 5:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:23 AM
Points: 7,098, Visits: 12,605
Yes, consider hiring someone who has setup DR/HA before to guide you through the process.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1429690
Posted Tuesday, March 12, 2013 6:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:44 AM
Points: 42,822, Visits: 35,953
Sen1 (3/11/2013)
I need to write DR/HA proposal any suggestions?


Do you have any HA/DR experience?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1429716
Posted Tuesday, March 12, 2013 10:16 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697
Like many subjects there's no magic solution and you have to figure out what works best for your organisation vs the cost and complexity.
DR and HA are different subjects anyway.
At the most simple level failover clustering and log shipping work well - I've usually found the sql server ( database ) solution is the simpliest part of finding a DR/HA solution for a whole application.
Handling data feeds, web sites, application tiers, web services, reporting, exports, logins, users, AD etc. are usually more of a challenge.
Oh and usually the "how much?" when you provide suggested solutions!


The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #1429930
Posted Wednesday, March 13, 2013 2:33 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, August 22, 2014 7:25 PM
Points: 191, Visits: 895
Colin is correct. HA and DR are two totally different animals. It is my opinion that you should first discuss with management and business units to determine their acceptable amount of data loss and time-to-restore parameters, and all others that are associated. Normally, these would then determine the HA and DR course that should be chosen. Can't create a plan until you know what you are trying to achieve, as different tools in the toolbelt are used for different requirements.

Just my 2 cents....
Post #1430638
Posted Wednesday, March 13, 2013 9:28 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, September 14, 2013 8:05 AM
Points: 101, Visits: 108
Do you have any HA/DR experience?
Post #1430721
Posted Friday, March 15, 2013 2:29 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:53 AM
Points: 4,350, Visits: 6,162
opc.three (3/12/2013)
Yes, consider hiring someone who has setup DR/HA before to guide you through the process.


+100


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1431754
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse