SQL Backup 7

Error - IO error on backup or restore restart-checkpoint file

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.

This error occurs when SQL Server's default backup directory does not exist.

  1. Open Registry Editor (regedit.exe).
  2. Locate the BackupDirectory registry entry in the the SQL Server registry folder:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.n\MSSQLServer\BackupDirectory
  3. 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.

Didn't find what you were looking for?