SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Restore Error!!!


Restore Error!!!

Author
Message
rambilla4
rambilla4
Right there with Babe
Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)

Group: General Forum Members
Points: 779 Visits: 777
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.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86112 Visits: 45229
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
Victor Alvarez-1138365
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 50
Hello Rambilla4,

Please check this post.

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

Regards,

Victor Alvarez
http://sqlpost.blogspot.com
rambilla4
rambilla4
Right there with Babe
Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)

Group: General Forum Members
Points: 779 Visits: 777
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
rambilla4
Right there with Babe
Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)Right there with Babe (779 reputation)

Group: General Forum Members
Points: 779 Visits: 777
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
justpassing
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 56
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
jarndt
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 17
Thank you for this tip. I checked my facets setting and it was an incorrect location.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search