Replication Problem?

Question

Hi.

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.

Thanks!!!

Answer 1

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.

Answer 2

Hi Mohammad.

But i have transactions not been replicated. If drop and create, this transactions will be replicated?

thanks.

Answer 3

are 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.


HTH.

Vinay

---

Vinay Thakur

Answer 4

Hi Vinay.

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.

Thanks.

Answer 5

is your replication is showing red mark?

check the status of the replication...

sp_changesubstatus 'publisherdb',@status='active'


http://msdn.microsoft.com/en-us/library/ms187344(SQL.90).aspx

use it carefully.
Edit: you may loose your data in transactions.

HTH

Vinay

---

Vinay Thakur

Answer 6

Hi Vinay

I recreated the replication and everything worked again.

Thanks!