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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy