Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transaction Replication Without Spanpshot Expand / Collapse
Author
Message
Posted Thursday, May 2, 2013 2:52 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 6:09 PM
Points: 53, Visits: 852
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
Post #1448984
Posted Thursday, May 2, 2013 4:37 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 5,886, Visits: 13,044
AFAIK you have to start with a snapshot to initialise the subscriber. No way round that.

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

Post #1449007
Posted Thursday, May 2, 2013 4:40 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:08 PM
Points: 17,967, Visits: 15,975
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
Post #1449009
Posted Thursday, May 2, 2013 4:48 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 5,886, Visits: 13,044
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!


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

Post #1449012
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse