Backup failure with error 112

Question

Backup failure with error 112

Helen-84411

Hall of Fame

Points: 3320
More actions
December 1, 2005 at 8:57 am

#170018

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

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Sameer Raval Hall of Fame Points: 3214 More actions · Answer 1

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

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 2

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/

Helen-84411 Hall of Fame Points: 3320 More actions · Answer 3

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

Stuart Davies SSCoach Points: 19505 More actions · Answer 4

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

SequelDBA Ten Centuries Points: 1093 More actions · Answer 5

We are seeing the same errors.

Operating system error 112(error not found).

Is this really a SPACE issue?

KU

tosscrosby SSCoach Points: 18045 More actions · Answer 6

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.

Backup failure with error 112

Cookies on SQLServerCentral