Solved

SQL Disaster recovery options

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
T-SQL Stored Procedure - Search multiple tables (Single column) for similar values 7 62
sql query Help 12 53
In or Between 2 44
SQL compatability in SQL 2016 2 31
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

896 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