Wednesday, September 29, 2010

DPM 2007 - Large SQL 2000 Inconsistent replicas

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.

No comments:

Post a Comment