Missing SQL Publication

[mkal]

I have Transactional replication set up between two sql 2000 servers. Today I noticed that there was an error on the subscriber, the error msg was: "The subscription to publication '(null)' has expired and does not exist." The step failed. I went to the publisher and to my surprise the publication was indeed not there.

So my question is, is there a way that SQL Server can delete a publication or is this something that can only be done manually, i.e. right-clicking a publication and choosing delete from the pop-up menu. If so how why would this happen? I can receate the publication but I would like to avoid this in the future.

Thanks!

 

[ptheriault]

I know that subscriptions can expire and I believe there is an option to delete the publication if the subscription expires. When I have set up replication in the past I have made sure to not have the subscription expire.

- Paul
- Database performance looks fine, it must be the Network!

 

[mkal]

Well I have no way of knowing now but I will definitely change that behavior for the next publication!

Thanks for the info
Mike