SQL Transactional Replication 2008 problems

  • Hi, i need help urgently on this one.

    I have transactional replication in place between two servers. These db's are rather large so i initialized via a backup, which worked fine (i think). I now get a message on my repl monitor under (distributor to Subscriber history) it states: "The initial snapshot for publication "db" is not yet available".

    Why would this be when i have initialized from backup? all transactions should be aligned?

    Please help 😉

  • For some reason you need to initialize transactional replication using a sql script, there is no way to do it via SSMS. Also, when you created your publication, did u specify that it would be initialized by a backup? Try this link for the sql to initialize.

    http://technet.microsoft.com/en-us/library/ms147834.aspx

  • Here is a sample script

    •Modify and execute the sql below on the publisher to create the subscription

    exec sp_addsubscription @publication = N'<publication name', @subscriber = N'<instance>', @destination_db = N'<destination database>', @sync_type = N'initialize with backup', @backupdevicetype = 'disk', @backupdevicename = 'd:\rep.bak', @subscription_type = N'push', @update_mode = N'read only'

    GO

  • Hi thanks for the reply...

    100%, the initialization was done via a sql script on SSMS. I also specified on publication to initialize from backup (if this is not enable the script won't run).

    However the problem was that:

    the script i had created a push subscription which i subsequently deleted, and created a pull subscriptions(simply to reduce load on the primary server).

    when i created the new subscription i did not specify "not to initialize from a snapshot".

    This caused the subscription not the talk correctly to the distributor.

    Thanks for the help guys!

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

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