Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmoore
Starting Member
2 Posts |
 Posted - 2008-10-21 : 11:05:12
|
| I'm receiving this error in SQL 2000 when we run a job:I/O error 1450(Insufficient system resources exist to complete the requested service.) detected during write at offset 0x00000ff30a8000 in file .mdf..Error: 823, Severity: 24, State: 4 |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-21 : 12:13:46
|
| This error indicates, OS resource crunch. This could potentially cause corruption, if you have lost writes. Error 823 is another indicator of corruption.I would suggets running DBCC CHECKDB against the database in question to rule out corruption. Set cap on SQL Server memory (Max Server Memory) to keep enough for OS. |
 |
|
|
fmoore
Starting Member
2 Posts |
Posted - 2008-10-21 : 12:36:15
|
| Can you explain what lost writes and DBCC CHECKDB is. |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-10-21 : 13:22:30
|
quote:
Originally posted by fmoore
Can you explain what lost writes and DBCC CHECKDB is.
try looking in the sql server help docs that come along with installation exe. You can find it online as well. Its very well described there.Refer this as well, http://support.microsoft.com/kb/304101 |
|
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-12-05 : 00:58:22
|
| Lost writes are when system is unable to write to disk. DBCC CHECKDB is database consistency checker command, which will tell you if your database integrity is intact.You can run DBCC CHECKDB command from SQL Server Management studio (or SQL Enterprise manager in SQl 2000) in the context of the database in question.Check Bokks online for details. |
|
|
|
|
|
|
I/O error 1450 in SQL 2000