Restore taking longer than normal suddenly

Question

Hi,

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

Answer 1

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?

Answer 2

Is it LiteSpeed restore? Checkout the following links:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81932

http://www.tek-tips.com/viewthread.cfm?qid=1102407&page=3

http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/a775a886-ab7e-461f-8413-4870678dc811

http://sqlserver.quest.com/thread.jspa?threadID=8626


Let us know if helpful.

---

Kalman Toth, SQL Server & BI Training, SSAS OLAP, SSIS, SSRS; http://www.SQLUSA.com

Answer 3

Have you deleted any backup folder from SQL server default backup location/?