November 16, 2008 at 9:42 pm
I got error like following :
Failed:(-1073548784) Executing the query "BACKUP DATABASE [MLM2_combin_20080401_153906] TO DISK = N'F:\\DEV\\SQL Backup\\Full\\Week3\\MLM2_combin_20080401_153906\\MLM2_combin_20080401_153906_backup_200811160300.bak' WITH NOFORMAT, NOINIT, NAME = N'MLM2_combin_20080401_153906_backup_20081116030004', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Write on "F:\\DEV\\SQL Backup\\Full\\Week3\\MLM2_combin_20080401_153906\\MLM2_combin_20080401_153906_backup_200811160300.bak" failed: 112(There is not enough space on the disk.)
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Actually i have seen that there are lots of space on the disk.
Please give me solution...
November 17, 2008 at 9:17 am
If you ran that BACKUP command manually, does it still give you the error?
Maybe someone cleaned out some space?
And make sure it is writing to the correct location (namely, F drive on the SQL Server)
November 17, 2008 at 10:12 am
it could be the backup is larger than the free space available!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply