SQL Server Performance

Trans Replication

Discussion in 'General DBA Questions' started by gkrishn, Apr 22, 2005.

  1. gkrishn New Member

    Hi i would like to implement Transactional repli among two servers (serv1 and serv2)

    I have same database in both servers. But i restored DB in serv2 two days after restoring DB in serv1 .mean to say there is some extra data there in DB in serv2. Hw can i go for Trans repli as both DB are not exacly same. any advice or pints anyone can give?

  2. deepakontheweb New Member

    if you have 2 days transaction log backup of serv1, apply on serv2.

    else you may need to run database snapshot while setting up tran replication.

    Deepak Kumar

    --An eye for an eye and everyone shall be blind
  3. gkrishn New Member

    Both are in Simple recovery model .

    Running snapshot will make both exact same DB ?
  4. deepakontheweb New Member

    No Problems with Recovery Model, you just need to identify replication screen like below: -


    **you can restore a full backup at subscriber server and while push/pull subscription wizard
    it ask you for initialize subscription like: -**

    specify wheather the subscription(s) need to be initialized. and if so, when to start the initialization process..

    Does microsoft SQL Server need to initialize the publicaiton schema and data at the subscriber when the subscription is created?

    you can select 'YES'

    Deepak Kumar

    --An eye for an eye and everyone shall be blind

Share This Page