Wednesday, October 14, 2009 1:11 PMHi.
My transactional replication has a problem. I was adding some items and suddenly gave problem and closed the SSMS. When he returned, got the following message: "The subscription to this publication is not active yet. No user action is required."
This is a problem? The number of Undistrubuted Commands keeps increasing, but does not replicate.
Wednesday, October 14, 2009 2:19 PM
use sp_dropsubscription to drop the exsiting subscription and create again.
Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.
Wednesday, October 14, 2009 2:28 PMHi Mohammad.
But i have transactions not been replicated. If drop and create, this transactions will be replicated?
Wednesday, October 14, 2009 5:29 PMare you sure replication was setup? was it working before?
you can resetup the replication and create the snapshot.
please provide more info so that we can help you better.
Wednesday, October 14, 2009 5:40 PM
Replication was working. But the SSMS it's closed suddenly and when i open again the replication was having problems.
The SSMS closed when I was adding some articles.
Wednesday, October 14, 2009 6:13 PMis your replication is showing red mark?
check the status of the replication...
use it carefully.
Edit: you may loose your data in transactions.
Thursday, October 15, 2009 6:36 PMHi Vinay
I recreated the replication and everything worked again.
- Marked As Answer by Xiao-Min Tan – MSFTModerator Friday, October 23, 2009 9:51 AM