Hi guys. I have a backup job that run every 3 days and backup everything on my SQL 2005 machine x64. From 3 weeks I have a big problem because after 3/4 hours the Client remote agent stop. It's automatic but never start up. I have not errors in the event log, the only problem is that I cannot backup my files.
If I try to run the backup in the morning, after restarted manually the Client remote agent on that machine, the backup runs.
I have also changed the user of this remote agent to the Network Admin ...
Maybe some problem with SQL2005.
(This happen starting when I installed the SP2 of SQL2005 three weeks ago).