Replicate database

  • Admingod

    SSCertifiable

    Points: 5829

    I am looking to replicate all the databases in a instance to DR location. I have approx 20 databases on this server and it needs DR plan. So all i can think is Always on AG with Async mode.  It would be critical application and synch would would be atleast 30 mins. Is there any other option other than Always on AG. Please advise? Thanks in Advance.

    • This topic was modified 2 months ago by  Admingod.
  • Phil Parkin

    SSC Guru

    Points: 244449

    Log shipping?

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

  • Admingod

    SSCertifiable

    Points: 5829

    I agree. But this is an old fashioned DR Solution right? Is there any benefits of Log shipping over Always on AG?

  • Phil Parkin

    SSC Guru

    Points: 244449

    I just did a quick search on the topic and there is loads of material out there already, written by people more qualified than I.

    But the answer I gleaned from reading was definitely yes, there are advantages (as well as disadvantages). You need to weigh up the pros and cons and decide which is best in your environment.

    It may be old technology but, as far as I know, there is no suggestion that it will be deprecated. It's tried and tested.

     

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

  • Admingod

    SSCertifiable

    Points: 5829

    In an event of disaster i think the data loss would more using log shipping when it compared to Always on AG group. Unless you schedule more frequent log backups.

  • Phil Parkin

    SSC Guru

    Points: 244449

    Before you go any further, make sure that you have your RTO and RPO defined and agreed by interested parties.

    This information will feed into the choice you make. Though it sounds like you have already made up your mind to use AGs.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

  • Admingod

    SSCertifiable

    Points: 5829

    Yes. However, i did not made up mind yet to use AGs. The major concern I have is that the server has two many databases(approx 20 - 30db) to configure for AGs ,so not sure if managing would become difficult?

  • Michael L John

    One Orange Chip

    Points: 25917

    I have 33 databases in one AG, totaling about 1.5 TB of space.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Admingod

    SSCertifiable

    Points: 5829

    Have you seen any issues with AG while configuring or managing with few databases Vs 33 databases?

  • Admingod

    SSCertifiable

    Points: 5829

    Since  SQL Server 2017 doesn't  require WSFC for AlwaysOn AGs. So i am thinking to configure AG without WSFC. Do you see any issues with this? Does it matter if it's Sync or Async mode?

Viewing 10 posts - 1 through 10 (of 10 total)

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