Re: Transaction Backup error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 15:53:01 -0400

David,

It sounds like your transaction log, the LDF, is in bad shape. This may
mean that you have a hardware problem with the disk that the log is on.
Check it out right away.

Russell Fields

"David Liu" <david.z.liu@moneris.com> wrote in message
news:786701c49500$19e42fe0$a301280a@phx.gbl...
> I got job failed, and error information for database xxxxx
> at sql logs:
> Internal I/O request 0x2973C868: Op: ReadLogScattered,
> pBuffer: 0x04300000, Size: 581632, Position: 67510272,
> EndingOffset: 68091904, SegLen: 983040, SegStride: 983040,
> UMS: Internal: 0x0, InternalHigh: 0x90000, Offset:
> 0x2EA5600, OffsetHigh: 0x0, m_buf: 0x04300000, m_len:
> 589824, m_actualBytes: 0, m_errcode: 1117, File:
> G:\Program Files\Microsoft SQL Server\MSSQL\xxxxx.LDF
>
> when I do manually backup log :
>
> I got
> Server: Msg 3271, Level 16, State 1, Line 1
> Nonrecoverable I/O error occurred on file 'G:\Program
> Files\Microsoft SQL Server\MSSQL\xxxxx.LDF'.
> Server: Msg 3013, Level 16, State 1, Line 1
> BACKUP LOG is terminating abnormally.
>
> Can do Full and Diff backup no problem.
>
> Thanks
> David Liu
> Sr. DBA
> MCSE/MCDBA
>

Relevant Pages