Solved

Sql Server: equivalent to Oracle Data Guard

Posted on 2015-01-20
6
1,001 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
  • 2
  • 2
  • 2
6 Comments
 
LVL 47

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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 47

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 500 total points
ID: 40565683
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

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.  …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

825 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