Wednesday, March 7, 2012

ReportIoError 2 - Further Info

Context
The first of the failed log backups was run after a series
of indexes on the database were rebuilt.
Recovery mode is changed to "bulk-logged" before rebuiding
indexes. This is followed by the log backup and then
recovery mode is changed back to "full".
Additional Error Messages in SQL Server Log
BackupMedium::ReportIoError: write failure on backup
device 'D:\mssql7\backup\Proclaim_backup.bak'. Operating
system error 2(error not found).
Internal I/O request 0x2E45D1A8: Op: Write, pBuffer:
0x3BE50000, Size: 65536, Position: 4293497344, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFE99200,
OffsetHigh: 0x0, m_buf: 0x3BE50000, m_len: 65536,
m_actualBytes: 0, m_errcode: 2, BackupFile: D:\mssql7
\backup\Proclaim_backup.bak
BACKUP failed to complete the command BACKUP LOG
[Proclaim] TO DISK = N'D:\mssql7
\backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
NAME = N'Proclaim backup', SKIP , STATS = 10, NOFORMAT
Hi Kim,
When ever you perform a recovery model change, it is always suggested to do
a full database backup and
then goahead with Transaction log backup.
This I/O issue can araises due to free space in hard disk, permissions on
the disk.
Thanks
Hari
MCDBA
"Kim" <anonymous@.discussions.microsoft.com> wrote in message
news:25bce01c46248$42024970$a601280a@.phx.gbl...
> Context
> --
> The first of the failed log backups was run after a series
> of indexes on the database were rebuilt.
> Recovery mode is changed to "bulk-logged" before rebuiding
> indexes. This is followed by the log backup and then
> recovery mode is changed back to "full".
>
> Additional Error Messages in SQL Server Log
> BackupMedium::ReportIoError: write failure on backup
> device 'D:\mssql7\backup\Proclaim_backup.bak'. Operating
> system error 2(error not found).
> Internal I/O request 0x2E45D1A8: Op: Write, pBuffer:
> 0x3BE50000, Size: 65536, Position: 4293497344, UMS:
> Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFE99200,
> OffsetHigh: 0x0, m_buf: 0x3BE50000, m_len: 65536,
> m_actualBytes: 0, m_errcode: 2, BackupFile: D:\mssql7
> \backup\Proclaim_backup.bak
> BACKUP failed to complete the command BACKUP LOG
> [Proclaim] TO DISK = N'D:\mssql7
> \backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
> NAME = N'Proclaim backup', SKIP , STATS = 10, NOFORMAT
|||Thanks for the suggestion.
I'll add a full backup to the scheduled job before and
after the recovery mode change and see if the issue
persists.

No comments:

Post a Comment