Search

Thursday, August 23, 2012

Backup job failed – no space Error 112

Generally we get 112 error for backup and other sql related error log errors as: 

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'xxx.BAK' failed, status = 112. See the SQL Server error log for more details. [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. 

DESCRIPTION: BackupMedium:: ReportIoError: write failure on backup device 'zzz.bak'. Operating system error 112(There is not enough space on the disk.). 

Note– “When you create a maintenance plan and maintenance plan job fails always check the history at maintenance plan history or report location to get the exact error” 
112 error means disk is occupied and full, and if you read the error it clearly specifies that there is not enough space. On this drive 

To solve this error:
  • Remove old backup unwanted files from that drive  
  • Move the backup or database files to another drive.  
  • Increase the drive size(external Drive SAN) 

2 comments:

  1. Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.
    SQL Server Training in Chennai

    ReplyDelete
  2. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

    ReplyDelete