Error - IO error on backup or restore restart-checkpoint file
Published 18 February 2013
When backing up or restoring, the following error may occur:
I/O error on backup or restore restart-checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL\backup\MyDatabase.ckp'.
Operating system error 3(The system cannot find the path specified.). The statement is proceeding but is non-restartable.
Operating system error 3(The system cannot find the path specified.). The statement is proceeding but is non-restartable.
This error occurs when SQL Server's default backup directory does not exist.
- Open Registry Editor (regedit.exe).
- Locate the BackupDirectory registry entry in the the SQL Server registry folder:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.n\MSSQLServer\BackupDirectory - Make sure that the BackupDirectory registry entry points to a location that exists. The SQL Server and SQL Server Agent services should have read/write permissions to the location.
