First you should remove all the subscriptions to the publication (check sp_dropsubscription, sp_subscription_cleanup, sp_droppullsubscription), then you should drop the publications (with sp_droppublication) and then you can disable replication in the...

Try to force the distribution agent to see if it is still working or if shows any error.

You can do this by running the Job of the distribution agent in...

be sure to check that the log reader agent is running. If you have transactions marked for replication and the log reader doesn't put them in the distribution database, then...

If you ment "lock", then you can deny access from EM.

I have always added a column with that sp, after the snapshot was applied. Because sp_repladdcolumn  add a column at the publisher and the subscriber when the distribution agent runs.

Try to...

No. Changing the recovery model doesn't affect replication.

I did it once. Can't give you all the step by step process.

Just remember that I build some .bat files, that prepare the dial process with RasDial command. Check the...

The trigger you losted, was at the publisher or subscriber?

Did you also restore the distribution database with the published database of the publisher?

Check the sync with backup option in BOL.

In the publisher, you must add the other server, as a valid subscriber. You can do this by right clicking in Replication/Configure Publishing, Subscribers... from EM, and adding the subscriber.

The...

By using sp_replAddColumn there is no need to regenerate the snapshot, also there is no need to pause the server as Microsoft suggest.

If you are using stored procedures to replicate transactions,...

Check if in the subscriber someone is making changes to the published tables, or also check for triggers that can be changing the replicated data.

Also you shoud check the stored...

Check that there isn't anothuer log reader running in the server. Maybe someone started from the command line.

Run sp_who2 to check the process and kill it, and then start the...

Still having the same problem. I have tried the last link you sent, but i have everything right.

The windows account I use to start sql services is member of the...

Mmm, I disagree.

The SQL Agent proxy account is a windows account in wich non sysadmin SQL users will use to access OS and network resources, by running xp_cmdshell or jobs.

All...