Thursday, March 04, 2010 10:30 AMHi,
i have setup a restore job on my database server, suddenly it start taking longer than normal, looking into event log i am seeing following two errors, what does these mean
1)The operating system returned the error '3(error not found)' while attempting 'DeleteFile' on 'T:\Backup\Database.CKP' at 'storage.cpp'(875).
2) During restore restart, an I/O error occurred on checkpoint file 'T:\Backup\Database.CKP' (operating system error 3(error not found)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
although we don't have T drive on my machine. we use to have T drive another rack attached to system but later on we have removed it.
Can anyone please explain me what's going on.. where i can actually look into it
Thursday, March 04, 2010 12:25 PM
Have you specified the restore must be done WITH STANDBY? if yes, then need to correct the path, which is pointing to T drive and now the drive is missing from your existing server.
Could you please provide the command you use to restore the database?
Thursday, March 04, 2010 12:31 PMModeratorIs it LiteSpeed restore? Checkout the following links:
Let us know if helpful.
Kalman Toth, SQL Server & BI Training, SSAS OLAP, SSIS, SSRS; http://www.SQLUSA.com
- Marked As Answer by MalikJaved Thursday, March 04, 2010 3:19 PM
Thursday, March 04, 2010 12:46 PMHave you deleted any backup folder from SQL server default backup location/?