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: Tuesday, September 27, 2016 9:29 AM
Points: 57, Visits: 1,137
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: 2 days ago @ 4:18 AM
Points: 6,141, Visits: 13,652
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: Friday, September 23, 2016 10:17 PM
Points: 20,008, Visits: 18,244
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: 2 days ago @ 4:18 AM
Points: 6,141, Visits: 13,652
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