Short version: Running a
RESTORE VERIFYONLY throws one of these errors:
During restore restart, an I/O error occurred on checkpoint file '\Server\Backup\SQLDirectBackup\DatabaseName\RestoreCheckpointDB24.CKP' (operating system error 5(Access is denied.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
During restore restart, an I/O error occurred on checkpoint file '\Server\Backup\SQLDirectBackup\DatabaseName\RestoreCheckpointDB11.CKP' (operating system error (null)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
- Using Ola's SQL Server Maintenance Solution
- The file share is on a Dell DR4300 device
- Has occurred on multiple servers using this device for backup storage
- Different servers, service accounts, versions of SQL Server have all thrown this error
- Not consistent or reproducible as far as I can tell (happened Monday & Wednesday but not Tuesday)
- Subsequent runs of the backup jobs have succeeded without error
- Time of day does not seem to be relevant, it's occurred at all hours
- The error is not immediate, it occurs minutes into the execution of the command
- Default backup directory points to
- Hasn't happened with an actual restore yet... but I'd like to avoid that. Hence the post.
I've never seen this error before, and all my research is coming up empty. It is possible that this has been happening for a long time but I am new to the company and only recently added Severity 16+ alerting so I cannot be sure.
Anyone have any ideas? Safe to ignore? Potential time bomb? I'm stumped.