I am getting this error:
Internal I/O request 0x05097428: Op: Write, pBuffer: 0x07400000, Size: 851968, Position: 4294580736, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFFA1A00, OffsetHigh: 0x0, m_buf: 0x07400000, m_len: 851968, m_actualBytes: 0, m_errcode: 112, BackupFile: i:\backups\warehouse_data.bak
BackupMedium::ReportIoError: write failure on backup device 'i:\backups\warehouse_data.bak'. Operating system error 112(There is not enough space on the disk.).
The command (t-sql) causing the error is:
backup database @.dbname to disk=@.backupTo with init
The available space on drive i: is approx 120Gb and the size of the database "warehouse" is apprx: 8Gb, so there is plenty of room on the target drive.
The source drive is rather short of space.
Can someone explain this ?Hi,
Is this I drive a local drive? Can you execute the below comand to check the
space free in I drive.
xp_fixedrives
If you have enogh space try executing the below command to backup from query
analyzer.
backup database <dbname> to disk='i:\dbname.bak' with init
Thanks
Hari
MCDBA
"Michael" <Michael@.discussions.microsoft.com> wrote in message
news:A033AA30-FEFB-47BF-A545-95638FC770F8@.microsoft.com...
> I am getting this error:
> Internal I/O request 0x05097428: Op: Write, pBuffer: 0x07400000, Size:
851968, Position: 4294580736, UMS: Internal: 0x103, InternalHigh: 0x0,
Offset: 0xFFFA1A00, OffsetHigh: 0x0, m_buf: 0x07400000, m_len: 851968,
m_actualBytes: 0, m_errcode: 112, BackupFile: i:\backups\warehouse_data.bak
> BackupMedium::ReportIoError: write failure on backup device
'i:\backups\warehouse_data.bak'. Operating system error 112(There is not
enough space on the disk.).
> The command (t-sql) causing the error is:
> backup database @.dbname to disk=@.backupTo with init
> The available space on drive i: is approx 120Gb and the size of the
database "warehouse" is apprx: 8Gb, so there is plenty of room on the target
drive.
> The source drive is rather short of space.
> Can someone explain this ?
>sql
No comments:
Post a Comment