Big file copy operation: Working Set Quota

[Albatross]

Hi Folks,

We have the following scenario:

- DL585, W2k3 Enterprise x64
- Opteron 2.2Ghz CPU, ~25% average
- 8GB RAM, ~40% free
- SQL 2005
- Gigabit LAN

As part of backup procedures, we use SQL Manager to create a daily database dump, wich is ~40GB in size. This big file is then copied across the LAN to another server running W2k3.

Each ~2 days the server stops responding at random during the copy operation, requiring a reboot. The following message appears:

"Cannot copy daily_dump.bak: Insufficient quota to complete the requested service"

After checking *disk* quotas and network configuration, nothing abnormal was found. Diggin deeper into MS Support Site and Google, we've found that the problem is not related to "disk" quotas, is related to Windows' "Working Set"

------------------------------------
Windows Error 0x000005AD - 1453
Insufficient quota to complete the requested service.
ERROR_WORKING_SET_QUOTA
------------------------------------

We are unable to proceed with daily tasks. Tape backup is already part of the internal policy, but we need to copy this file over the LAN.

Any help and insight will be *vastly* appreciated.

SE

[Igor Karasik]

Probably you can divide 40 Gb file to 4-5 smaller files and when copy ?

And did you tried to do same copy WITHOUT antivirus ?

[Ivan Ferreira]

Please see if this link helps you:

http://www.red-gate.com/support/kb/KB200708000139.htm

Also I saw that some products as "Computer Associates" may cause this problem. Verify if you have some antivirus program that may cause the problem.