Home Forums SQL Server 2005 Backups Operating system error 112(There is not enough space on the disk) RE: Operating system error 112(There is not enough space on the disk)

  • October 7, 2009 at 4:31 am

    #1062673

    okiftequar (10/7/2009)

    Hi dear friends,

    Weekly i m monitoring on my sql server 2005. Today i have found a error in my sql server error log file,

    Error: 18210

    'BackupMedium::ReportIoError: write failure on backup device 'F:\MSSQL Backup\Default Instance\mydb\mydb_backup_200910051356.bak'. Operating system error 112(There is not enough space on the disk.).’

    I checked the drive space but there is lot of space available on my F: drive the total size is suppose 20GB so there is near about 12gb is free space. still i m getting this error.

    Can anybody tell me the reason of this.

    Thanks in advance.

    Regards,

    M.I.

    You havent mentioned when this error occurred, could there be a overnight job that took all the space and then released it when finished that clashed with this backup job. how big is your backup normally for this database.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]