Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restore Error on ckp file

Author  Topic 

scottpt
Posting Yak Master

186 Posts

Posted - 2004-03-01 : 14:57:35
Error:
"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."

What file is this?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-01 : 15:09:36
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".

Is the database really on the C drive? Databases should be installed on the non-OS array.

Tara
Go to Top of Page
   

- Advertisement -