Post reply

Automatically syncing database to different server

  • July 25, 2014 at 11:53 am

    #293700

    Hi all,

    I have a quick question, hopefully someone can point me in the right direction.

    We have two SQL 2012 servers, sever A and B.

    We need to sync a database on A so that there is a copy of it on B (ideally keeping the sync as real time as possible).

    We need to be able to query both databases so mirroring isn't an option.

    Can anyone suggest a way of doing this?

    Thanks in advance,

    L

  • July 25, 2014 at 12:13 pm

    #1732485

    Always On AGs or replication. You could also do log shipping but this be delayed.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • July 25, 2014 at 12:14 pm

    #1732486

    Hi

    Does replication require clustering? It can be delayed if needed so real time isn't a massive issue..

    Thanks

  • July 25, 2014 at 12:15 pm

    #1732487

    Possibly transactional replication.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • July 25, 2014 at 12:19 pm

    #1732490

    roadkillchicken (7/25/2014)

    Hi all,

    I have a quick question, hopefully someone can point me in the right direction.

    We have two SQL 2012 servers, sever A and B.

    We need to sync a database on A so that there is a copy of it on B (ideally keeping the sync as real time as possible).

    We need to be able to query both databases so mirroring isn't an option.

    Can anyone suggest a way of doing this?

    Thanks in advance,

    L

    replication or AlwaysON, I suggest AlwaysOn that way you can leaverage clustering.

    MCSE SQL Server 2012\2014\2016

  • July 25, 2014 at 12:20 pm

    #1732491

    Thanks all - I'll take a look at transactional replication. Does anyone have a good (and easy) step by step guide?

  • July 25, 2014 at 12:22 pm

    #1732493

    roadkillchicken (7/25/2014)

    Thanks all - I'll take a look at transactional replication. Does anyone have a good (and easy) step by step guide?

    http://www.databasejournal.com/features/mssql/article.php/1438201/Setting-Up-Transactional-Replication-A-Step-by-step-Guide.htm

    MCSE SQL Server 2012\2014\2016

  • July 25, 2014 at 2:52 pm

    #1732546

    roadkillchicken (7/25/2014)

    Hi

    Does replication require clustering? It can be delayed if needed so real time isn't a massive issue..

    Thanks

    If you can have server B delayed then log shipping with a stand-by secondary might be worth looking into as well. The down side of using a standby log shipped secondary is you either have to disconnect all users when restoring logs or has your restores wait/fail until nobody is connected.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

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