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 02, 2013 2:52 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:24 PM
Points: 41, Visits: 668
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 02, 2013 4:37 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:14 AM
Points: 5,844, Visits: 12,571
AFAIK you have to start with a snapshot to initialise the subscriber. No way round that.

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

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


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 7:28 PM
Points: 20,453, Visits: 14,063
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1449009
Posted Thursday, May 02, 2013 4:48 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:14 AM
Points: 5,844, Visits: 12,571
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