Backup Failed With Error 112
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Backups »
Sql Backup Failed 112
Backup failure with error 112 Backup failure with error 112 Rate Topic sql server backup error 112 Display Mode Topic Options Author Message Helen-84411Helen-84411 Posted Thursday, December 1, 2005 8:57 AM SSC Veteran Group: General Forum Members
Operating System Error 112(failed To Retrieve Text For This Error. Reason 15105)
Last Login: Monday, April 29, 2013 11:00 PM Points: 210, 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 operating system error 112(error not found) 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 isBACKUP 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 netbackup status 112 up(Without NOSKIP).Any pointers as to why this error is appreciated Helen--------------------------------Are you a born again. He is Jehova Jirah unto me Post #241176 Sameer RavalSameer Raval Posted Thursday, December 1, 2005 9:43 AM Mr or Mrs. 500 Group: General Forum Members Last Login: Friday, December 13, 2013 8:04 PM Points: 546, 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 Post #241205 colin.Leversuch-Robertscolin.Leversuch-Roberts Posted Friday, December 2, 2005 6:46 AM SSCrazy Group: General Forum Members Last Login: Wednesday, April 27, 2016 3:18 AM Points: 2,687, Visits: 715 Error 112 always means not enough disk space at that point in
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more http://dba.stackexchange.com/questions/140500/sql-server-backup-error-112-not-enough-space-on-the-disk-true-or-not about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top SQL error 112 Server: backup error 112: not enough space on the disk - true or not? up vote 2 down vote favorite 1 Last night my weekly backup on SQL Server 2014, running on Windows Server 2012 R2, failed with the following error in the log: failed with the following error: "A nonrecoverable I/O error occurred on file "D:\MSSQL\MSSQL12.MSSQLSERVER\Backup\backup-xxxx.bak:" 112(There is not enough space on the disk.). When I checked disk space I found there was still 1 GB free, operating system error and the .bak file looked ok, all 4GB of it, not compressed. So I ran a RESTORE VERIFYONLY command on that file: RESTORE VERIFYONLY FROM DISK = 'D:\MSSQL\MSSQL12.MSSQLSERVER\Backup\backup_xxxx.bak' that responded: The backup set on file 1 is valid. So which version of the story should I trust? Note: According to Pinal Dave (http://blog.sqlauthority.com/2016/04/14/sql-server-backup-randomly-failing-error-112-not-enough-space-disk/) the first error is not accurate, especially if using compressed backups. sql-server backup share|improve this question edited Jun 7 at 11:48 marc_s 5,38132743 asked Jun 6 at 10:43 simonpa71 364 Are you compressing the backup or not though? –Molenpad Jun 6 at 10:50 1 Run RESTORE HEADERONLY ... to see what date the backup was taken. Perhaps the backup is actually from the previous week. –Max Vernon Jun 6 at 10:52 2 Also if you didn't back up with INIT, the backup operation that caused the error might not have been the backup stored as file 1. SQL Server doesn't raise out of space issues for fun and games, it only does that when it actually comes across a space problem, in spite of whatever Pinal might say about it. –Aaron Bertrand♦ Jun 6 at 10:53 What Pinal is saying might be related to your scenario if you are using compression. Yes the way compression works for allocating space is bit different. But the crux is during backup SQL Server is not able t