May 2, 2013 at 4:05 pm
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
May 2, 2013 at 4:39 pm
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 3, 2013 at 1:12 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply