SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup failure with error 112


Backup failure with error 112

Author
Message
Helen-84411
Helen-84411
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2888 Visits: 29

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
Sameer Raval
Sameer Raval
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2822 Visits: 255

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
colin.Leversuch-Roberts
SSC-Forever
SSC-Forever (48K reputation)SSC-Forever (48K reputation)SSC-Forever (48K reputation)SSC-Forever (48K reputation)SSC-Forever (48K reputation)SSC-Forever (48K reputation)SSC-Forever (48K reputation)SSC-Forever (48K reputation)

Group: General Forum Members
Points: 48287 Visits: 715
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.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Helen-84411
Helen-84411
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2888 Visits: 29

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
Stuart Davies
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17555 Visits: 4897

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 Smart way to ask a questionThere 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
SequelDBA
SSC Eights!
SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)SSC Eights! (931 reputation)

Group: General Forum Members
Points: 931 Visits: 1118
We are seeing the same errors.

Operating system error 112(error not found).

Is this really a SPACE issue?

KU
tosscrosby
  tosscrosby
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16777 Visits: 5316
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search