Post reply

Transactional replication problem

  • November 27, 2008 at 3:19 am

    #70957

    I have SQL 2005 . I create transactional replication with pull subscritpion.

    I had sheduled the replication after every 1 hr.

    When I start the SQL server agent manually to generate the snap shot it shows me message

    " (0%)"a snapshot was not generated because no subscription needed initialization".

    Please tell me why this message occured? is this error? How can I understand that my replication is running normally?

  • November 27, 2008 at 12:43 pm

    #904469

    Hi,

    On the Publisher,

    - navigate to Replication/Local Publications

    - right-click the Publication you are interesed in and choose "Launch Replication Monitor".

    - expand the + sign next to the name of the Publisher, select the Publication in the tree view

    You can now do two different things things;

    1. in the right-hand pane; double-click he subscription to view a list of actions OR

    2. right-click the Publication in the left-hand pane and choose Validate Subscriptions.

    Needless to say # 2 can take quite a bit of time depending on your choices in the Validation Options dialog and how much data are in the tables.

    HTH!

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • November 27, 2008 at 2:27 pm

    #904486

    v.g.mujumdar (11/27/2008)

    Please tell me why this message occured? is this error? How can I understand that my replication is running normally?

    It's not an error. In transactional replication the snapshot's only needed to create the inital subscription, and again any time the subscription becomes invalid. If everything's running smoothly, you don't need to run a snapshot every hour and if you try to, you'll get a message like this saying that a new snapshot isn't necessary.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 30, 2008 at 11:10 pm

    #905387

    Gr8 Thanks. I got my answer.

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

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