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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-18 : 09:11:20
|
| Brandon writes "I have been receiving this error periodically in doing backups. The backup will fail. It doesn't matter if it is a full backup or a transaction log backup.The error is as follows:Internal I/O request 0x6E704D78: Op: ReadLogScattered, pBuffer: 0x0B270000, Size: 983040, Position: 5930033152, EndingOffset: 5932025856, SegLen: 983040, SegStride: 983040, UMS: Internal: 0x20202020, InternalHigh: 0x70012020, Offset: 0xD29200, OffsetHigh: 0x0, m_buf: 0x0B270000, m_len: 983040, m_actualBytes: 0, m_errcode: 1450, File: ...................The error is typically accompanied with the following error:BackupIoRequest::WaitForIoCompletion: write failure on backup device 'yadayada.ldf'. Operating system error 1450(Insufficient system resources exist to complete the requested service.).Typically, if I restart the backup, the job will succeed. However, I have seen it where this will go on all day. That makes me nervous. When I ran into this on an all day situation, I ran DBCC CheckDb and that fixed things that day. That was on a weekend however when I can get away with doing something like that.Any suggestions for preventative medicine in the future? Aditionally, does anyone have a general guideline they follow as to how frequently to run DBCC CheckDB?" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-19 : 20:18:41
|
| Did you actually get any errors reported from CHECKDB ?This sounds very much like a hardware issue with either the drives or their controller. You need to runs some diagnostics on your hardware to check for any problems. I doubt things will improve until you repair the hardware.HTHJasper Smith |
 |
|
|
|
|
|
|
|
Internal I/O request