Post reply

db sync

  • June 30, 2011 at 1:08 pm

    #253803

    Hi Experts,

    I need to automate task to sync db from server1 to server2. The process we manually do is backup from server1.db1 to a share folder in server2 and then restore server2.db1 from that backup in shared location.

    The problem i face when automate job is to take backup of server1.db1 from server2.

    Is it possible if i create a linked server of server1 in server 2 ?

    Please help

    TIA

  • June 30, 2011 at 1:17 pm

    #1346716

    I would absolutely waive off on linked servers. What is the second server used for? Maybe log-shipping?

    CEWII

  • June 30, 2011 at 2:40 pm

    #1346751

    Is it Replication??

    Regards
    Sushant Kumar
    MCTS,MCP

  • June 30, 2011 at 6:50 pm

    #1346823

    I don't quite understand the problem. You can automate all the steps.

    I did something similar a while back with 2 sql servers on different domains.

  • July 2, 2011 at 6:41 pm

    #1347502

    Thanks all for the response

    Not replication and log shipping..

    Month end task to sync databases on server2 with server1.

    I am able to do via linked server by creating job that will backup server1.db to a shared location on server2 and restore from there..

    Is there any better way to achieve this?? what about a snapshot replication??

  • July 3, 2011 at 12:44 pm

    #1347556

    I don't see a linked server being necessary at all.

    If the requirement is a once a month sync then a restore is probably the simplest. The other options are better for more current data.

    CEWII

Viewing 6 posts - 1 through 5 (of 5 total)

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