Restore Error!!!

Question

Restore Error!!!

rambilla4

SSCrazy Eights

Points: 8715
More actions
August 6, 2009 at 2:28 pm

#213137

Hi,
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.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Did you specify the restore must be done WITH STANDBY?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Victor Alvarez-1138365 SSC-Addicted Points: 494 More actions · Answer 2

Hello Rambilla4,

Please check this post.

http://www.sqlservercentral.com/Forums/FindPost307316.aspx

Regards,

Victor Alvarez
http://sqlpost.blogspot.com

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 3

Here is my Restore Script:

RESTORE DATABASE MyDB

FROM DISK='D:\Backups\MyDB.bak'

WITH RECOVERY, REPLACE, STATS = 10,

MOVE 'MyDB_DATA' TO 'D:\SQLDATA\MyDB.MDF',

MOVE 'MyDB_log' TO 'D:\SQLLOG\MyDB.LDF'

GO

And I remember that, I have deleted the folder "Backup" from the path D:\Microsoft SQL Server\MSSQL.1\MSSQL as I'm not using the default location for backups.

Is this the reason for these errors? Can we delete the Backup folder from the default location?

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 4

Hi,

Its interesting!!! I have created "backup" folder in the path D:\Microsoft SQL Server\MSSQL.1\MSSQL and after that I'm not getting the restore error in the error log !!!

Is this a bug??

justpassing Valued Member Points: 71 More actions · Answer 5

This is an old thread but I thought I'd post a reply as it may help others searching for a solution.

This will only work for 2008 sqlservers and up.

1, in SSMS right click the server name in object explorer and choose "facets" from the drop down menu

2, next to "facets" click the drop down and choose "Server Settings"

3, change the "BackupDirectory" entry to a valid location

jarndt Valued Member Points: 51 More actions · Answer 6

Thank you for this tip. I checked my facets setting and it was an incorrect location.