sql 2000 ent frequently get insufficient memory error when backing up on tlog or do a bulk import, even now increased to 8GB from original 2GB.
After restart sql server service, then able to run bulk import, noticed buffer increased around 260MB. of cause tlog can be backup too after sql restart.
Don't have any clue now, can someone give some advice or hint? OS is w2k3 Ent 32bit.
View Complete Post