Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore Error!!! Expand / Collapse
Author
Message
Posted Thursday, August 6, 2009 2:28 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 17, 2010 11:02 AM
Points: 347, 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.
Post #766547
Posted Thursday, August 6, 2009 2:46 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:50 AM
Points: 42,451, Visits: 35,506
Did you specify the restore must be done WITH STANDBY?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #766560
Posted Thursday, August 6, 2009 2:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 21, 2009 1:18 PM
Points: 20, Visits: 50
Hello Rambilla4,

Please check this post.

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

Regards,


Victor Alvarez
http://sqlpost.blogspot.com
Post #766564
Posted Thursday, August 6, 2009 3:57 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 17, 2010 11:02 AM
Points: 347, 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?
Post #766602
Posted Saturday, August 8, 2009 12:25 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 17, 2010 11:02 AM
Points: 347, 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??
Post #767377
Posted Thursday, August 2, 2012 8:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 6:11 AM
Points: 1, Visits: 41
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




Post #1339211
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse