We had a customer that had 3 large SQL Databases approx 30 - 40 gb each and could not get their DPM 2007 Protection group fully synced.The databases were on a Windows Server 2003 Enterprise edition server with Service Pack2.
This is the error we were getting
DPM encountered an error while performing an operation for <\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy1372\Program Files\Microsoft SQL Server\MSSQL\Data\....mdb> (id 2033: insufficient system resources exist to complete the requested service (0x800705aa))
So the insufficient system resources is the part I focused on and through some research on the web these are the steps I took to resolve the issue.
1. Changed the Virtual Ram on DPM Server from system managed to a custom size. The size I chose was double the physical amount of ram.
2. Installed hot fix from Article ID: 940349 This hot fix updates the vss writers on the windows 2003 server.
3. The apply method one from this Microsoft Article ID: 304101
4. Reboot the protected Server in this case the Windows 2003 Enterprise server and reboot the Dpm server. When both are backup. Start a consistency check and that's it.
Of the steps I have described above, I am not sure if all steps are required but I am sure it resolved the problem we were having.