Solved

restore fails after -g option added for SQL server

Posted on 2004-10-18
4
705 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

739 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