Day 5: 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 ‘xxx.bak’. Operating system error 112(There is not enough space on the disk.).

 

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

 

Resolution:

>> Remove old backup/un-wanted files from that drive

      >> Increase the drive size(external Drive SAN)

      >> Move the backup or database files to another drive.

 

 

Advertisements
This entry was posted in Backup and Restore, Troubleshooting and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s