Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am getting the below error while I am trying to do a restore. Can you please suggest a fix?

Backup,Unknown,During restore restart an I/O error occurred on checkpoint file 'd:\dwd\smot\res.CKP' (operating system error 3(The system cannot find the path specified.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.

Backup,Unknown,Error: 18272 Severity: 16 State: 1.

Thank you

share|improve this question

migrated from Apr 6 '11 at 17:19

This question came from our site for professional and enthusiast programmers.

It sounds like one of these scenarios:

  • The file isn't at 'd:\dwd\smot\res.CKP'
  • The file is there but the process that is attempting to restore it does not have read permissions.
  • The file is there and the permission are good, but the file is corrupt.
share|improve this answer
The fix for #2 is obvious, but is there a way s/he could create (or re-create, if corrupt) the checkpoint file - preferably non-destructively? – voretaq7 Apr 6 '11 at 18:36
I was hoping the original poster would give us some insight into which it was. Unfortunately if it's #3, s/he is most likely out of luck. The only way to fix the issue is to create another backup file / checkpoint file. And the only way to do so that I'm aware of is to have the original database up and running. Of course, if you're trying to restore from a file, that usually means that the original database isn't available. – RQDQ Apr 6 '11 at 20:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.