Can anyone suggest ways to troubleshoot this error.
First error came during a transaction backup
BackupDiskFile::CreateMedia: Backup device '\\server1\.....' failed to create. Operating system error 1450(Insufficient system resources exist to complete the requested service.).
Then SSIS packages started failing. A reboot seemed to rectify things.
Microsoft SQL Server 2005 - 9.00.4060.00 (Intel X86) Mar 17 2011 13:20:38 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Dedicated SQL Server.
There are 4 GBs of memory. SQL Serevr max mem is set to 2700 MBs.
/3GB switch is set in the boot configurations. I am contemplating lowering SQL server max memory.
Any comments/suggestions welcome.
thanks