Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2004-03-08 : 11:28:32
|
| Hi, We moved to new SAN 3 months ago and no problems so far. We changed the restore script to point to the correct directories and drive letter. Restore works fine but in the log an error appears which indicates old directory path. What is causing this?--ErrorLog 2004-03-05 09:37:27.76 spid70 I/O error on backup or restore restart-checkpoint file 'P:\Program Files\Microsoft SQL Server\MSSQL\backup\HR8QA.ckp'. Operating system error 3(The system cannot find the path specified.). The statement is proceeding but is non-restartable.---- Here is the restore script:-- Refreshes HR8QA from HR8PRD.use masterRESTORE FILELISTONLY FROM DISK = '\\DTC_PSPRD\X$\BACKUP\Nightly\HR8PRD\HR8PRD_db_200312252100.BAK'--RESTORE DATABASE HR8QA FROM DISK = '\\DTC_PSPRD\X$\BACKUP\Nightly\HR8PRD\HR8PRD_db_200312252100.BAK' WITH MOVE 'HR8PRD_Data' TO 'K:\HR8QA_Data.mdf', MOVE 'HR8PRD_Log' TO 'L:\HR8QA_Log.ldf', STATS = 2GO-- EndWhere is the question of path 'P:\Program Files ......' appearing anywhere listed in the above error? Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2004-03-09 : 11:30:42
|
| We figured out that even though this error was not causing any restore issues, it was appearing with the old path due to the entries in registry. In fact, we saw there were other folders with old path even after we moved to SAN.Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
 |
|
|
|
|
|
Error during restore