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 Snapshot Expand / Collapse
Author
Message
Posted Thursday, May 2, 2013 4:05 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 12:54 PM
Points: 50, Visits: 772

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. I am using SQL 2008

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 #1449005
Posted Thursday, May 2, 2013 4:39 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 4:09 PM
Points: 21,252, Visits: 14,960
duplicate thread

please post here
http://www.sqlservercentral.com/Forums/Topic1448984-1292-1.aspx#bm1449007




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 #1449008
Posted Friday, May 3, 2013 1:12 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:21 PM
Points: 809, Visits: 1,160
I have given you all the steps in thred

http://www.sqlservercentral.com/Forums/Topic1447153-291-1.aspx#bm1447334

But again here it is.

• Set up Publication.
• Set transaction retention to 120 hours for distribution
• Disable the distribution clean up job on the distribution DB
• Setup Publication and set the "allow initalization from backup files" option for the publication
• Make a full backup of the database on the publisher DB
• Restore the full backup on the subscriber DB
• Ran the following stored procedure on the publication database:
-- Run this on publisher DB
sp_addsubscription
@publication ='Publication Name', --Publication Name
@subscriber='servername', --servername of subscriber
@destination_db='SubscriberDB Name', -- Database name where you want to replicate the data
@sync_type = 'initialize with backup',
@backupdevicetype = 'disk',
@backupdevicename = 'Location where the backup was placed' --Location where the back up was placed on subscriber.

go
Post #1449337
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse