I restore a database MyDB from Production SQL Server 2005 EE to a query server, sql server 2005 developer edition. The restore job is running succesfully with out any errors. But I noticed the following error messages in Error Log and I did not understand what these errors refering to even though the restore job running fine?
Error: 3633, Severity: 16, State: 1.
2009-08-06 12:46:40.41 spid58 The operating system returned the error '3(The system cannot find the path specified.)' while attempting 'DeleteFile' on 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyDB.CKP' at 'storage.cpp'(875).
2009-08-06 12:46:41.17 Backup Error: 18272, Severity: 16, State: 1.
2009-08-06 12:46:41.17 Backup During restore restart, an I/O error occurred on checkpoint file 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyDB.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.
2009-08-06 12:46:44.25 spid58 Starting up database 'MyDB'.
2009-08-06 12:46:44.66 spid58 The database 'MyDB' is marked RESTORING and is in a state that does not allow recovery to be run.
2009-08-06 12:46:44.90 spid58 Starting up database 'MyDB'.
2009-08-06 12:46:45.64 spid58 CHECKDB for database 'MyDB' finished without errors on 2009-08-01 22:00:12.523 (local time). This is an informational message only; no user action is required.