Transaction Replication Without Spanpshot

  • Hi Experts,

    I want to build up a Transaction Replication but without Snapshot. I know how to build replication with the Snapshot but this time the request is to build it without snapshot as the snapshot takes a lot of disk space on distributor server.

    Please guild me Step by Step process or if there is any Tutorial for it.

    I appreciate all your help

    Thank you so much

  • AFAIK you have to start with a snapshot to initialise the subscriber. No way round that.

    ---------------------------------------------------------------------

  • Here is an article on that topic

    http://technet.microsoft.com/en-us/library/ms151705(v=sql.105).aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • well that will teach me to post on something I haven't done for a while, still least I had the sense to put AFAIK.

    Still sounds like it will be cheaper in the long run to get the disk space! 🙂

    ---------------------------------------------------------------------

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

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