Sql Server: equivalent to Oracle Data Guard

Posted on 2015-01-20
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.
Question by:mkhandba
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
LVL 50

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?

Author Comment

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.
LVL 24

Expert Comment

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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

LVL 50

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.

Author Comment

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

Accepted Solution

mankowitz earned 500 total points
ID: 40565683

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Database Owner 3 41
Oracle perfomance issue. 4 48
T-SQL: problem comparing datetime 4 75
Oracle Join issue. 3 43
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
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

738 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