Solved

SQL Disaster recovery options

Posted on 2011-03-02
4
265 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

760 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

17 Experts available now in Live!

Get 1:1 Help Now