Viewing 15 posts - 151 through 165 (of 1,790 total)
Where are you getting the errors from, the distribution agent or are you querying the distribution database MSrep_errors table?
These are definitely odd errors and I have never seen either....
November 30, 2011 at 1:43 pm
If you manually start the snapshot agent that error should go away.
November 30, 2011 at 1:37 pm
This was answered - http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/2e30bde8-ed2b-4541-80ba-0061c1d2c28a
November 30, 2011 at 1:27 pm
Jeff - Congratulations! Truly a well deserved award. I can easily say that your articles / posts have had a significant impact on my skills as a DBA, which is,...
September 15, 2011 at 1:58 pm
So are you trying to reinitialize the whole publication?
September 6, 2011 at 2:54 pm
I guess it would be good to back up here so that I can understand where you are at in the process with this publication / subscription. Has this been...
September 6, 2011 at 8:30 am
The glowing yellow box around the text you quoted gets your attention doesn't it. 🙂 Thanks Greg - appreciate the feedback on this.
August 25, 2011 at 1:58 pm
amita pallod (8/25/2011)
sp_repldone will delete the transactions which are in distributor and didn't make it to subscriber yet
I believe that it actually resets the LSN but also marks all the...
August 25, 2011 at 11:48 am
Again, note, all transactions that have not been replicated will be marked as replicated and you have to do a manual sync.
Just want to make sure you understand the...
August 25, 2011 at 11:40 am
You're correct, all would fail. My apologies. You will need to do the following;
1. Stop logreader
2. Open a new connection to that database in SSMS. (Critical that you are...
August 25, 2011 at 11:39 am
Can you see the failed subscription in replication monitor?
There are a couple of ways to fix it - the easiest being to drop the subscription, recreate it WITHOUT initializing....
August 25, 2011 at 11:16 am
Based on your error it looks like the LSN's for the transactions are out of sync. I don't know of a way to fix that without losing the transactions that...
August 25, 2011 at 9:59 am
scott.shaw (8/24/2011)
Nice technology but very frustrating.
Agreed. Mainly in that the tools are not there yet, not even in the ability to script things and make them automated. Definitely doesn't work...
August 25, 2011 at 7:32 am
There is a incorrect join condition on the first join as follows;
JOIN sys.dm_tran_session_transactions [tst]
ON tat.transaction_id = tat.transaction_id
That should be tat.transaction_id = tst.transaction_id
Hope this helps.
August 4, 2011 at 11:39 am
opc.three (7/28/2011)
July 28, 2011 at 11:25 am
Viewing 15 posts - 151 through 165 (of 1,790 total)