I had same issue on windows 2012 R2 server and SQL 2012 SP2 install base. I had to manually grant the nt service\SQLServerAgent rights as shown in this article:

Maybe I didn't catch your purpose, but if replication is trying to delete a row at the subscriber, why did you bother with a data sync? Are you assuming there...

I found one cause for issues for everything but sql agent job alert notifications working. The original DBMail setup stores the default profile in the registry when you setup DBMail...

I think your issue is very poor performance on the backup disk, or even your source disk. Test against a faster disk and see if speed increases.

-Chuck

You could use my backup script, or look at the code on how I did it. http://www.sqlwebpedia.com/content/ultimate-ms-sql-backup-script

-Chuck

@SQLGuyChuck

Try to at least do this in all your insert statements. Relying on order can get you into trouble when schema changes down the road.

INSERT INTO SERVER2.database.dbo.table (dbg_step, dbg_desc, dbg_datetime)

SELECT...

The SQL engine will attempt to find the proc in the Master db first. So this will slow finding the proc down a little. Better to use prc_ or some...

I also have a huge list of free tools. It has gone beyond just SQL tools, but very server administrator focused. http://www.sqlwebpedia.com/content/free-sql-server-tools

Chuck Lathrope

@SQLGuyChuck

What about instead of this:

SET @PersonID = (SELECT SCOPE_IDENTITY() PersonID)

do this:

SET @PersonID = SCOPE_IDENTITY()

Inside the remote stored procedure you capture the identity and return it as a parameter.

-Chuck

Any possibility of changing to a stored procedure?

-Chuck

You could look a replicating the data out in transactional one-way (read only for users) subscriptions to a load balanced group of servers. I do this for similar reason with...

There is also some DTC config you may need to go through...wrote it up on my site as I have dealt with this a million times. http://www.sqlwebpedia.com/content/msdtc-troubleshooting

I also created a huge proc and database to track backups. My backup proc is 1500 lines of code and can do litespeed or native backups and can do just...

If you had to reinstall the OS, you will have to reinstall SQL to the same version and patch level so you can attach your database files if they are...