Post reply

Basic Availability Group on SQL Server 2014 Standard

  • July 11, 2016 at 8:31 am

    #315010

    Hello Everyone,

    I would like this solution and wanted to know if is possible to be done:

    Two Nodes Windows 2012 R2, one active one passive.

    Sql Server 2014 Standard One active sending logs to the passive Node (instance) with no shared disk.

    In Oracle there is a solution called Dataguard that let me do that and I need to implement a SQL server solution similar to what Oracle offers.

    Thanks in advance.

  • July 11, 2016 at 10:26 am

    #1889466

    I was researching and i find out that the mirroring offers exactly the same as oracle Dataguard.

    But also found that is going to be deprecated soon, but is still available in SQL SERVER 2016, so i'm going with that solution.

    Thanks for all the viewers of the post.

    Paul Vidal

    DBA.

  • July 11, 2016 at 11:07 am

    #1889482

    paul.s.vidal (7/11/2016)

    I was researching and i find out that the mirroring offers exactly the same as oracle Dataguard.

    But also found that is going to be deprecated soon, but is still available in SQL SERVER 2016, so i'm going with that solution.

    Thanks for all the viewers of the post.

    Paul Vidal

    DBA.

    I promise you I will have clients still using database mirroring 15 years from now. Works fine, lasts a LONG time. 🙂

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply