November 29, 2009 at 9:58 pm
failed with the following error: "A nonrecoverable I/O error occurred on file "F:\SQLBAK\Data\xyz_backup.bak:" 112(There is not enough space on the disk.).
this system having 4 GB ram
F: disk space 45GB
there is no other job running in this time.
please help me on this to resolve this problem
November 29, 2009 at 10:03 pm
Are you trying to backup the database or restore? No details mentioned.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 29, 2009 at 11:00 pm
i am trying taking backup through job.
November 30, 2009 at 2:07 am
what is the size of the db that you are backing up and what other things are there on F drive ?
November 30, 2009 at 4:44 am
Hi
"There is not enough space on the"
I looks like the Drive(LUN) you are backing into run out of free space.
Please delete some old files from the drive and try again.
good luck
Guy H
November 30, 2009 at 10:17 am
The error from the OS is a simple error that means what it says. There is not enough space. If you get any errors that have OS Error in them, it's the same error you would get on your workstation when performing that action. Permissions/space/etc.
November 30, 2009 at 10:33 am
Since the database is larger than the free space available on your drive, the backup is failing. You can include additional file (on a different drive) to be included in your backup and that would have your backup written into multiple equal files, solving your problem.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply