1
Vote

failed: 112(There is not enough space on the disk.)

description

Trying to backup 5GB sql DB and getting this error.
"System.Data.SqlClient.SqlException (0x80131904): Write on "C:\Program Files\SQLBackupFTP\SQLBackupFTPTemp\hqdatabase20120816005727\DBBackup\hqdatabase20120816005727.bak" failed: 112(There is not enough space on the disk.)
BACKUP DATABASE is terminating abnormally"
NTFS formated HD and Has 300GB of free space.
Any help is appreciated.

comments

mdelgert wrote Sep 9, 2012 at 6:14 PM

Your drive is too full to backup your DB.

calvinm wrote Nov 26, 2012 at 4:25 PM

I've experienced the same error on a backup. In our case, there's over 60 GB of free space on the backup drive at the point of failure. We have a job that saves serveral DBs, some being 30 GB+, that get backed up fine along the way, but fails on one DB that's less than 3 GB. The backup works every other day or so, so I'm not convinced it's a space issue.

wrote Feb 14, 2013 at 12:14 AM