Solved

restore fails after -g option added for SQL server

Posted on 2004-10-18
4
699 Views
Last Modified: 2012-06-21
This restore failure happened one day after we started using -g option for SQL server's start up parameter, and also upgrade to SQL litespeed 3.1 from 3.0. Anyone has seen similar errors or knows the cause?  

We are win 2k3, enterprise edition sql 2000, sp3a with additional security patch, NAS device for disk, awe enabled, 8 proc, 8GB (6GB max mem for sql server)

Thanks!


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

....

2004-10-18 22:04:55.50 spid131   Error: 947, Severity: 16, State: 1
2004-10-18 22:04:55.50 spid131   Error while closing database '[database name removed]' cleanly..

0
Comment
Question by:loveviolet
  • 2
  • 2
4 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 12344000
Did Microsoft or Imceda recommend you change the -g option?  This is usually an option you don't mess with unless you've been receiving errors in the event log that warrant it.

We've been running Litespeed and SQL in the same environment as you (SAN instead of NAS) and we haven't experienced any problems.

Judging by this question and your previous questions, I still think you have some NAS issues....
0
 
LVL 1

Author Comment

by:loveviolet
ID: 12344113
Microsoft recommended us to add the -g option, to get away with the memory allocation problems.  Now when we remove the -g, it seems like it's working now.  However, we still want to know why this is happening.  Maybe you are right, it is NAS...
0
 
LVL 1

Author Comment

by:loveviolet
ID: 12364547
So we are trying to rebuild the machine.  Another thing that the management decided to test is to increase the memory from 8GB to 16GB.  Is there anything we should be aware of, such as some registry settings or memtoleave settings?  

Thanks!
0
 
LVL 34

Accepted Solution

by:
arbert earned 500 total points
ID: 12364850
Pretty much the same thing as with the 8gb---leave enough memory for Windows and any other apps/drivers that run on the box.  Don't over allocate to SQL Server.  You should also get a baseline test to see if the extra memory helps or hurts SQL Server since AWE can have a lot of overhead...
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now