Problems with Database backup

  • I get the following errror when I try to backup my DB. I know that I have at least 10 the space available on the disk. I am running SQL 2000 with SP2 version 8.00.194. Any help will be greatly appreciated.

    Thanks

    CJ

    -------------------------------------------

    BackupMedium::ReportIoError: write failure on backup device 'D:\SQL Backup\HM.BAK'. Operating system error 112(There is not enough space on the disk.).

    Internal I/O request 0x1D472A20: Op: Write, pBuffer: 0x1DC50000, Size: 983040, Position: 4294187520, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFF41A00, OffsetHigh: 0x0, m_buf: 0x1DC50000, m_len: 983040, m_actualBytes: 0, m_errcode: 112, BackupFile: D:\SQL Backup\HM.BAK

  • Is this the case for every database or only a specific one ?????

    In other words is the backup failing just for this database or for all databases.

  • So far I have tried to backup only one database (about 5 GB size).

  • Did you check the Event Viewer logs, cometimes the error message is better there.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply