Transaction replication guidance needed

A co-worker left my company and now I am responsible for the replication we have setup b/t two databases on the same server.  I have a number of questions that were not answered by my reading of MSDN KB.  Hopefully some experts can help me out.

BACKGROUND
- We use a one-way push transaction replication from one db to another on the same instance of SQL Server 2005
- Currently the activity level is very low...to the extent that it may be days before a record needs to be replicated
- The publications contains ~12 articles, some of which are filtered

The questions I have at the moment are;

(1) If the subscription is set to "Subscriptions never expire, but they can be deactivated until they are reinitialized", what will cause a subscription to deactivate?  Can inactivity cause a subscription to deactivate?

(2) If inactivity can cause a subscription to deactivate, after how many days/hours will the deactivation occur?

(3) If inactivity can cause a subscription to deactivate, does this mean rows will cease to replicate?

(4) If inactivity can NOT cause a subscription to deactivate, what is the next logical step(s) to troubleshoot when I receive a "Performance Critical" warning in Replication Monitor?

(5) Where in Replication Monitor can I see when a subscription was last reinitialized?

Thanks in advance,
-Tim
Start Free Trial