October 18, 2004 at 7:45 pm
We are running SQLServer Enterprise Edition, 8GB, 8proc, Win 2003 Server, sp3a. Our disk is a netapp. We just added the -g384 startup parameter. The max memory setting is 6GB. We use a Dell 6650, with hyperthreaded cpu. We are running SQLLitespeed backup & restore utility, version 3.1.0.2. SQLLitespeed is invoked from our application code, in order to backup & restore our databases on a schedule.
We hit this error today, the backup succeeded but the restore failed with this:
2004-10-18 21:50:28.06 backup BackupIoRequest::WaitForIoCompletion: write failure on backup device ''. Operating system error 1450(Insufficient system resources exist to complete the requested service.).
2004-10-18 21:50:28.11 spid127 Internal I/O request 0x45B51420: Op: WriteDatabaseScattered, pBuffer: 0x24950000, Size: 1048576, PageNumber: 0:0, UMS: Internal: 0x46707CE8, InternalHigh: 0x46707EA0, Offset: 0x46707E48, OffsetHigh: 0x45B983A8, m_buf: 0x24950000, m_len: 68, m_actualBytes: 0, m_errcode: 1450, File: n/a
2004-10-18 21:50:28.17 backup BackupIoRequest::WaitForIoCompletion: write failure on backup device ''. Operating system error 1450(Insufficient system resources exist to complete the requested service.).
2004-10-18 21:50:28.19 spid127 Internal I/O request 0x45B51420: Op: WriteDatabaseScattered, pBuffer: 0x24950000, Size: 1048576, PageNumber: 0:0, UMS: Internal: 0x46707CE8, InternalHigh: 0x46707EA0, Offset: 0x46707E48, OffsetHigh: 0x45B983A8, m_buf: 0x24950000, m_len: 68, m_actualBytes: 0, m_errcode: 1450, File: n/a
2004-10-18 21:50:28.22 backup BackupIoRequest::WaitForIoCompletion: write failure on backup device ''. Operating system error 1450(Insufficient system resources exist to complete the requested service.).
2004-10-18 21:50:28.25 spid127 Internal I/O request 0x45B51590: Op: WriteDatabaseScattered, pBuffer: 0x24A50000, Size: 1048576, PageNumber: 0:0, UMS: Internal: 0x45B63118, InternalHigh: 0x45B63118, Offset: 0x45B63118, OffsetHigh: 0x45B63118, m_buf: 0x24A50000, m_len: 1169568024, m_actualBytes: 0, m_errcode: 1450, File: n/a
October 21, 2004 at 8:00 am
This was removed by the editor as SPAM
October 23, 2004 at 4:48 am
Take a look at this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304101
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply