Had a SQL Server 2005 FULL Backup failure each night for the largest database (around 45GB). Looking at the SQL Server Logs I notice the following error:-
BackupMedium::ReportIoError: write failure on backup device 'D:\BACKUP\SERVER_DATABASE_FULL_20160103_202215.bak'. Operating system error 665(error not found).
Looking at possible solutions:-
- Backup HD drive is heavily fragmented, but as this is a SAN then that is not really possible.
- Drive is compressed
Checking the drive and yes it was compressed so the network guys turned this off and bingo all we managed a full nightly backup.