Post reply

Transactional Replication

  • June 30, 2009 at 12:19 am

    #103775

    We have online card management system (where, no downtime allowed.)

    We need to implement transactional replication to another sql server. The data is about 18GB. I am wondering, how can we do without any downtime during applying snapshot on subscriber? I thought of taking a full backup and apply to subscriber. Do you have any suggestion to overcome this issue?

    The servers are in SQL Server 2000 SP4

  • June 30, 2009 at 12:47 am

    #1017393

    Implementing Replication would not require downtime. But you can do it on off hours. It does not require backup and restore. Instead you can create Publication and subscription and transfer the data.

  • June 30, 2009 at 1:09 am

    #1017398

    Thanks suresh. But there is no 'Off hours' since the application runs on 24 X 7.

  • June 30, 2009 at 1:19 am

    #1017400

    Hi Moorthy,

    Replication does not require any downtime. But generation of snapshot causes some overhead on the server. so it is recommended to generate the snapshot during when there is less activity on the server. In 2005 there is a option for generation of snapshot quickly(i dont remember the option exactly). Check out on google. Did u checkout a trial run on ur test server.

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • June 30, 2009 at 1:46 am

    #1017406

    But while implementing the replication, the initial step would be creating snapshot, which actually transfers the entire schema of the articles you defined along with the data to the subscriber. This would slow down the application until it get completed. But i hope there is no other way if you are setting up Replication.

  • June 30, 2009 at 3:46 am

    #1017430

    Thank you mohan and suresh. I agree with you. i would generate snapshot during non-peak hours. Thanks again.

  • June 30, 2009 at 5:13 am

    #1017472

    I suggest you initialize your subscription from a full backup of your production database, this wont consume resources on your production db as compared to generating a snapshot where a lock is placed on the subscribed articles and modifications on the tables under consideration are not allowed until snapshot is generated..


    Pradeep Singh

  • June 30, 2009 at 5:48 am

    #1017491

    http://kodeexii.net/blog/current-events-computer-technology/transactional-replication-without-snapshot.html

    As suggested by Pradeep Singh, you can refer the mentioned link.

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

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