Sharepoint Backups Failing

[Michael_Willi1]

I am unable to get a sharepoint backup as the agent keeps faulting with the following error

Event Type:Error
Event Source:Application Error
Event Category:(100)
Event ID:1000
Date:23/01/2007
Time:1:19:07 PM
User:N/A
Computer:FATTONY
Description:
Faulting application beremote.exe, version 11.0.6235.0, faulting module bedssql2.dll, version 11.0.6235.2, fault address 0x000378f3.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 62 65 72 ure ber
0018: 65 6d 6f 74 65 2e 65 78 emote.ex
0020: 65 20 31 31 2e 30 2e 36 e 11.0.6
0028: 32 33 35 2e 30 20 69 6e 235.0 in
0030: 20 62 65 64 73 73 71 6c bedssql
0038: 32 2e 64 6c 6c 20 31 31 2.dll 11
0040: 2e 30 2e 36 32 33 35 2e .0.6235.
0048: 32 20 61 74 20 6f 66 66 2 at off
0050: 73 65 74 20 30 30 30 33 set 0003
0058: 37 38 66 33 78f3


Any ideas? I have used liveupdate to update the server to Hotfix 6, I then deployed the agent via a push.

[Jeff_Zankofsky]

If this is a remote install of SPS, I would remove and reinstall the Remote Agent first as the first step. If this doesn't fix the problem, you may want to stop all non-essential services on this server to see if something else like anti-virus software is interfering.

[Kevin_Mast]

I am having the same issue with the Sharepoint Agent. crashing the beremote.exe process. I was attempting to narrow some things down last night and it only happens if I try to backup more than one of the SP databases at a time. I was able to back up all 4 databases successfully when I ran 4 separate jobs. If i add any 2 of the 4 databases to the job it crashes the agent on the SQL Server. However I can backup all the other databases residing on the SQL server using the sql agent without any issues as long as I leave the Sharepoint selections unchecked. I have already tried uninstalling and reinstalling the agent with no luck. I guess it is time to open up a case.

[Kevin_Mast]

Couple more observations

1. If I turn off the AOFO option all the databases backup fine through the Sharepoint Agent.
2. If I leave the AOFO option turned on and use the SQL agent for all the same sharepoint databases they back up fine.

So the agent only crashes on the SQl Server when I use both the AOFO option and the sharepoint agent. I find it strange that it works fine using AOFO and SQL Agent