Error during Backup for large SQL database
Posted on 2004-08-11
I'm making a regular scheduled daily backup for the database of our ERP system, it was done successfully until the mdb file size exceeded the 20 GB. I'm making the backup on Tape , and also on Disk. There is no problem for Tape, but the Backup on Disk is not successful anymore. The SQL server in on win2k server which has NTFS volumes, the volume on which the Data and Backup resides has 38 GB free space. The mdb size now is 22 GB and the ldb size is 7GB. After the error occur, I find these messages on the following logs :
Write on 'e:\mssql\BACKUP\Everyday Backup' failed,status = 112. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3202)
BackupDiskFile::OpenMedia: Backup device 'e:\mssql\BACKUP\Everyday Backup' failed to open. Operating system error = 2(The system cannot find the file specified.).
BackupMedium::ReportIoError: write failure on backup device 'e:\mssql\BACKUP\Everyday Backup'. Operating system error 112(There is not enough space on the disk.).
The E: disk is at or near capacity. You may need to delete some files.
What would be the possible reasons for this problem, and what is the solutions for it ?