?
Solved

Sql Server: equivalent to Oracle Data Guard

Posted on 2015-01-20
6
Medium Priority
?
1,417 Views
Last Modified: 2015-01-27
We are using Sql Server: 2008 R2, and looking for some solution like Oracle Data Guard.

Please do share the best options + best practice doc/link too.

Thanks in advance.
0
Comment
Question by:mkhandba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40559975
I think there's nothing as Dataguard is SQL Server but some features only.
Are you searching for some specific feature?
0
 

Author Comment

by:mkhandba
ID: 40559991
Basically we are looking for high availability, currently using SVC to achieve this HA, this is the primary goal that if by any reason our Primary goes  down, how fast we can be up & running on the secondary db/location or whatever we can achieve, in the fastest and best possible manner.

We are currently in the process of evaluating and come up with the best possible options for our scenario.
0
 
LVL 24

Expert Comment

by:mankowitz
ID: 40560044
I think you are looking for Always On Availability Groups, which exists in 2012 and onward. For 2008r2, you want a failover cluster. See this page for a walkthrough http://msdn.microsoft.com/en-us/library/ms189134(v=sql.105).aspx
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40560072
If you are only looking for HA feature then as mankowitz wrote, the answer is AlwaysOn but don't exist on you SQL Server version. Problem with failover cluster is that you'll lose connection during the failover and there's no secondary database for you connect as read-only for reporting purposes for example.
0
 

Author Comment

by:mkhandba
ID: 40565035
can you please share some link/best practice doc in reference to 2012 high availability features.
0
 
LVL 24

Accepted Solution

by:
mankowitz earned 2000 total points
ID: 40565683
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

765 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