Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Friday, December 2, 2016 8:50 AM
Points: 57, Visits: 1,198
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: Wednesday, November 16, 2016 9:57 AM
Points: 6,147, Visits: 13,680
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Monday, November 21, 2016 11:03 AM
Points: 20,009, Visits: 18,255
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: Wednesday, November 16, 2016 9:57 AM
Points: 6,147, Visits: 13,680
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