I've two SQL servers with multiple DBs. On both, I've set up maintenance tasks using the Ola procedures. One DB server is Enterprise SQL with Agent and the other is Express using Win scheduler to run procedures.
All database backups are done towards a network share (QNAP NAS) with plenty of space (800Gb with 750GB still free). ALL of the backups, of system DBS and user DBS works perfectly but, a differential backup of the main user DB is always failing with I/O error,
Message 3271, gravity 16, error 112 Not enough space on disk
which obviously is a false error reason. I'm running FULL backups at 6:00 and 20:00 with DIFF backups at lunch break (13:00). In between LOG backups every hour. Please note that ALL of the other backups run, even the DIFF backups on smaller user DBs, the only one failing is always on the same DB (which is the biggest, most important and active).
- All checks on DB give no errors.
- Networks shares works.
- Surfing forum I noticed that others are experiencing such I/O error erratically.
- SQL Server version is 13.0.5101.9