Solved

SQL Disaster recovery options

Posted on 2011-03-02
4
280 Views
Last Modified: 2012-05-11
We have a an important application sitting on a SQL box (physical) and a need a solution to provide good DR.

We have a remote site in mind to host the DR hardware so log shipping is most likely out of the question(?) The solution should remain 'dark' until invoked, can anyone suggest anything suitable which thye have experience of please?

I've used double take and I'm not really a fan TBH. I'm not a DBA as you might of guessed so please excuse me in advance.
0
Comment
Question by:samymac
4 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 167 total points
ID: 35019620
I would always start with Microsoft as they build SQL and suposedly they should have best options/solutions: http://support.microsoft.com/kb/822400

But sometimes there are busines rules that do not apply to their solutions and you could look further:
http://searchsqlserver.techtarget.com/tip/Choosing-a-SQL-Server-disaster-recovery-solution
0
 
LVL 17

Assisted Solution

by:dbaSQL
dbaSQL earned 167 total points
ID: 35024222
0
 
LVL 2

Assisted Solution

by:Umesh_Madap
Umesh_Madap earned 166 total points
ID: 35131027
1 st of all you have to figure our how critical is your data.
and how frequent you want data to be refreshed on other server.

you can use replication also 3 types of replications
1) transactional replication
2) snapshot
3) merge replication

u have to chose as per you requirements.
 
0
 

Author Closing Comment

by:samymac
ID: 35466488
I'll share the points as the work seems to have gone away for now.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

786 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