SQL Server Performance Forum – Threads Archive

Are there errors on my harddisk????

When I perform transaction log backup,the following errors show: (Backup log ACER to Disk=’D:ACERBackupACER_LOG.TRN’ with init ) 1. BackupMedium::ReportIoError: write failure on backup device ‘D:ACERBackupACER_LOG.TRN’. Operating system error 2(The system cannot find the file specified.).
2.Internal I/O request 0x7D098048: Op: Write, pBuffer: 0x088B0000, Size: 983040, Position: 822613504, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x31081600, OffsetHigh: 0x0, m_buf: 0x088B0000, m_len: 983040, m_actualBytes: 0, m_errcode: 2, BackupFile: D:ACERBackupACER_LOG.TRN What happened?I think there are some errors(logical or physical) on my disk(raid 5)! But the storage send no warning signal out! Please help me! Thans!

Check the correct path is specified and the account used to perform this statement has required privileges to write the files in the specified path.
For any hardware issues refer to the event viewer log. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks,satya!
I have checked the path and the account. They all are right. This statement always succeeded before and often fails recently.

Also run dbcc checkdb. If possible run a h/w disk consistency check. i/o errors like this often do point to hardware (disk, controller etc) problems in my experience. Tom Pullen
DBA, Oxfam GB

If you’re using any third party tool for backup purpose then ensure the specified path and file is not locked by other process. And as adivsed by Tom run the CHECKDB during less traffic hours in order to ensure there are no inconsistency issues with the data storage. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks,satya and Tom Pullen. I have run dbcc checkdb(acer) on the server and find no any error! I also have checked the specified path and file is not locked by other process!

Are you using Database maintenance plan to perform log backups?
If it fails next time try to look at the maintenence log file for further informaton as specified in this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;288577 HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>