Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Operating system error 1450(Insufficient system resources exist to complete the requested service.) Expand / Collapse
Author
Message
Posted Thursday, July 18, 2013 6:09 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 1:15 PM
Points: 653, Visits: 3,831
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
Post #1475240
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse