SQL Transaction Log Backup error

[rmwagner]

I have the following SQL running in a job:
BACKUP LOG [BellSouthADSL] TO DISK = N'D:\MSSQL2K\MSSQL\Backup\BellSouthADSL\BellSouthADSL_TransLog.bak' WITH NOINIT , NOUNLOAD , NAME = N'BellSouthADSL Tran backup', NOSKIP , STATS = 10, NOFORMAT

Last night it began to fail after 2 months of working fine. Nothing was changed last night, and I can't seem to find anything helpful regarding this error:

Server: Msg 823, Level 24, State 3, Line 1
I/O error 87(The parameter is incorrect.) detected during write at offset 0x0000001e01a000 in file 'd:\MSSQL2k\MSSQL\data\BellSouthADSL_Data.MDF'.

Connection Broken


Does anyone have any ideas?

Thanks,
Robert Wagner

 

[JayKusch]

Did you try re-running the job?

Thanks

J. Kusch

 

[rmwagner]

Yes, I re-ran the job with the same result, then grabbed the SQL from the job and ran it in QA to produce the error.

Thanks,
Robert Wagner

 

[skippaNH]

Have you tried renaming the existing backup file and rerunning the job?

 

[rmwagner]

No luck. The error is in the Data file. Is there some way to run an integrity check on the data file?

 

[rmwagner]

I ran DBCC CHECKDB and DBCC CHECKFILEGROUP
Both returned no errors. Meanwhile I haven't got a backup in two days. Does anyone have any other ideas?

 

[JayKusch]

May have a bad disk ... can you run checkdisk on the D: drive?

Thanks

J. Kusch

 

[rmwagner]

I ran checkdisk through utilities on drive properties (without the fix boxes checked, to avoid having to reboot right now), and it didn't detect any problems.

Thanks,
Robert Wagner

 

[JayKusch]

do you have another drive, say E:, that you can test the command against?

Thanks

J. Kusch

 

[rmwagner]

Yes, but they are all in the same RAID 10 array. Do you think it would still help?

Thanks,
Robert Wagner

 

[JayKusch]

Yes ... if you have the room on the partition.

Thanks

J. Kusch

 

[Laura2]

Hi Robert,

How did you get rid of this error? We've been able to back up but the error is still showing. We've done everything you put in the post with no luck.

Thanks,

Laura.