When running Log Shipping during the restore restart, an I/O error occurred on checkpoint file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupdatabasename.CKP'
Error may include: "I/O error on backup or restore restart-checkpoint file 'C:\Program Files\Microsoft SQL Server\MSSQL\backup\LAW.ckp'. Operating system error 3(The system cannot find the path specified.). The statement is proceeding but is non-restartable."
When you run a restore, a checkpoint file is created. For checkpoint information in regards to a restore, check out the topic in BOL titled "Checkpoints and the Active Portion of the Log".
or the following error may appear:
Error: 18272, Severity: 16, State: 1.
During restore restart, an I/O error occurred on checkpoint file 'G:\MSSQL.1\MSSQL\Backup\databasename.CKP' (operating system error 1784(error not found)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
During these restores, a checkpoint error was logged in the windows system event log.
It doesn't matter that the source is 64-bit and destination is 32-bit, this has been successfully tested.
© ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center