May 2, 2013 at 2:52 pm
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
May 2, 2013 at 4:37 pm
AFAIK you have to start with a snapshot to initialise the subscriber. No way round that.
---------------------------------------------------------------------
May 2, 2013 at 4:40 pm
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
May 2, 2013 at 4:48 pm
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