December 1, 2005 at 8:57 am
Hi there,
I have this error when performing database backup (using maint plan)
BackupMedium::ReportIoError: write failure on backup device 'K:\MSSQL\Bkup\xxx_OR\xx_OR_200512010117.BAK'. Operating system error 112(There is not enough space on the disk.).
But drive K contains 353 GB of hard disk space. How can i interpret this error. Is this I/O issue. The command executed is
BACKUP DATABASE [xxx_OR] TO DISK = N'K:\MSSQL\Bkup\xxx_OR\xxx_OR_200512010117.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT.
I have restarted the backup with FORMAT option and now it is in the processes of backing up(Without NOSKIP).
Any pointers as to why this error is appreciated
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me
December 1, 2005 at 9:43 am
A maintenance plan does not overwrite the old backup file. It creates a new backup file, and then deletes the old backup file after creating the new one. It needs enough space for 2 backups files bacause of this. This is the safe way to do backups, because you always have a backup file on disk.
The solution is to make sure you have enough disk space for 2 backup files.
What is the size of your database. I know with 353 Gb available space the pointer I reference may not be the case.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
December 2, 2005 at 6:46 am
Error 112 always means not enough disk space at that point in time. Do you have other disk ops on that disk at that time - make sure the recycle bin isn't containing files.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 2, 2005 at 7:16 am
Hi Sameer,
The size of the database is 112 GB. However there was no previous backup in the drive.(Infact all 353 GB space is free). If I run the backup from QA with the following command [ I have restarted the backup with FORMAT option and now it is in the processes of backing up(Without NOSKIP).]
BACKUP DATABASE [xxx_OR] TO DISK = N'K:\MSSQL\Bkup\xxx_OR\xxx_OR_200512010117.BAK' WITH INIT , NOUNLOAD , STATS = 10, FORMAT.
The backup was successful now(used FORMAT instead of NOFORMAT). I wonder what could be the reason
Thanks in advance
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me
May 25, 2007 at 2:53 am
I'm having a similar problem but the error is "operating system error 112 error not found".
Again - I've got more than enough disk space 114 Gb on NTFS 136 Gb drive.
I can't backup a 7 gb database
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 29, 2008 at 7:41 am
We are seeing the same errors.
Operating system error 112(error not found).
Is this really a SPACE issue?
KU
April 29, 2008 at 12:00 pm
It may not simply be disk space. It could also be rights to the share (did not know that!) if it says "error not found". I always looked at error 112 and thought of disk space, and for Helen, I think it is. Check this out:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1762258&SiteID=1
-- You can't be late until you show up.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply