replication setup-sync type - social.msdn.microsoft.com
Sep 20, 2012 · I have setup replication using the sync type option replication support only. If I need to reinitialize the subscriptions of any publication, do I need to completely drop the subscription and …
How do you find a transaction given the LSN
Jul 10, 2013 · Reinitialize seemed safer. Perhaps sp_repldone is a better option if the publication data set is very large? Or.. is reinitialize the same as the sp_repldone reset=1. Thank you for your time...
Restore the primary database of a log shipping configuration
Jul 15, 2013 · Reinitialize log shipping from the scratch (full backup - restore). There are tons of additional things you could do, e.g. use STANDBY during log restore to be able to read the data in a …
Merge replication - Generate script for pending changes at subscriber
May 10, 2016 · I need to reinitialize an replication without the option "Upload pending changes", and I have pending changes in the subscriber side which I don't want to lose. Is there a way to detect this …
Msg 18752, Level 16, State 1, Procedure sp_repldone, Line 1 Only one ...
Oct 26, 2015 · Check to see if there are any application locks being held and if so release them. Then issue an sp_replrestart and then try to issue the sp_repldone command. By issuing the sp_repldone …
Transaction log is not releasing space even after all the transaction ...
Aug 30, 2012 · Kalaikarthik - I would advise you not to do this as you will need to reinitialize your subscriptions. Best thing to do is to change your database recovery model from simple to full and …