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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 30, 2011 at 1:43 pm
If you manually start the snapshot agent that error should go away.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 15, 2011 at 1:58 pm
So are you trying to reinitialize the whole publication?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 4, 2011 at 11:39 am
opc.three (7/28/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 28, 2011 at 11:25 am
Viewing 15 posts - 151 through 165 (of 1,790 total)