January 9, 2014 at 12:52 pm
Hi,
I am setting up the replication. I heard there are some stored procedures to check the latency. Please let me know those stored procedures names to find the latency b/n publisher & subscriber.
And what stored procedure we have to use when I want to delete old data from publisher and doesn't want reflect those deletion operation in the subscriber.
Thanks in advance.
January 10, 2014 at 8:49 am
If you want to do it programmatically have a look at:
sp_posttracertoken
http://technet.microsoft.com/en-us/library/ms176091.aspx
and
sp_helptracertokenhistory
http://technet.microsoft.com/en-us/library/ms187349.aspx
A bit more reading here: http://technet.microsoft.com/en-us/library/ms147309(v=sql.105).aspx
Otherwise, you can always insert a tracer in Replication Monitor> Select the Publication> and "Insert Tracer"
As far as deleting data from the publisher, but leaving at the subscriber... hmmm. That sort of defeats the purpose of replication (as designed). You might transfer those records out of the subscriber table into another non-replicated table to save them? Sounds like you might be using replication as an archiving solution?
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
January 10, 2014 at 12:06 pm
Thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply