User Tools

Site Tools


Sidebar

Announcement

Ahsay Backup Software

Backup Set Types

Supported Storage

Features in OBM / ACB

Features in CBS

Brand and Customize

License

Documentation

Performance Testing

FAQs and Known Issues

Can't Find What You Need?

public:5295_there_is_not_enough_space

[V7] ISSUE: A nonrecoverable I/O error occurred on file 112 (There is not enough space on the disk) (MS SQL database backup)

Article ID: 5295
Reviewed: 2018-01-26

Product Version:
AhsayOBM: Post-7.3.0.0
OS: Windows

ATTENTION 1st January, 2022: v7 officially End-of-Life [details]

Problem Description

When performing a MS SQL database backup (ODBC backup mode), the following warning message is received in the backup report:

No. Type Timestamp Log
* ... ... ...
* info ... [Start] Backing up "SQL_hostname\MSDB\db_name" ... to "temp_path"
* warn YYYY/MM/DD hh:mm:ss [Microsoft][ODBC SQL Server Driver][SQL Server] A nonrecoverable I/O error
occurred on file "temp_path\backupset_id\...\db_name\db_name.bak.YYYY-
MM-DD-hh-mm-ss.ADD:"112 (There is not enough space on the disk.).
* ... ... ...

Cause

The message suggests that there is insufficient free space in the temporary directory for storing backup files.

Resolution

To resolve the issue, ensure that there is sufficient free space available in the temporary directory for storing backup files. Alternatively, configure the temporary directory to another volume (accessible by the MS SQL service) with sufficient disk space.

Keywords

sql, odbc, temp, space, sufficient, in-sufficient, enough, mssql

public/5295_there_is_not_enough_space.txt · Last modified: 2021/12/16 06:12 by anna.olalia

Page Tools