Sql Server - Restore failed due to an incorrect path in MS-SQL-Server MOVE script(2830)

[mohamed_souidi]

3/11/2015 9:18:55 AM - begin reading
3/11/2015 9:19:08 AM - Info dbclient(pid=872) done. status: 2830: Restore failed due to an incorrect path in MS-SQL-Server MOVE script
3/11/2015 9:19:08 AM - Info bpbrm(pid=11112) child done, status 2830         
3/11/2015 9:19:08 AM - Info bpbrm(pid=11112) sending message to media manager: STOP RESTORE dzorrpw24_1423350026     
3/11/2015 9:19:08 AM - end reading; read time: 0:00:13
3/11/2015 9:19:09 AM - Info bpbrm(pid=11112) media manager for backup id dzorrpw24_1423350026 exited with status 0: the requested operation was successfully completed
3/11/2015 9:19:09 AM - restored image dzorrpw24_1423350026 - (Restore failed due to an incorrect path in MS-SQL-Server MOVE script(2830)); restore time 0:02:18
3/11/2015 9:19:14 AM - end Restore; elapsed time: 0:02:26
Restore error(2850)

3/11/2015 9:19:08 AM - Info dbclient(pid=872) ERR - Error in DBthreads::dbclient: 6.       
3/11/2015 9:19:08 AM - Info dbclient(pid=872)     CONTINUATION: - Le fichier spécifié est introuvable.  
3/11/2015 9:19:08 AM - Info dbclient(pid=872) ERR - Error in VxBSAEndData: 6.       
3/11/2015 9:19:08 AM - Info dbclient(pid=872)     CONTINUATION: - The handle used to associate this call with a previous VxBSAInit() call is invalid.
3/11/2015 9:24:00 AM - Info dbclient(pid=872) ERR - Error in VDS->Close: 0x80770004.       
3/11/2015 9:24:00 AM - Info dbclient(pid=872)     CONTINUATION: - An abort request is preventing anything except termination actions.
3/11/2015 9:24:00 AM - Info dbclient(pid=872) INF - OPERATION #1 of batch C:\Users\access\Desktop\Restore1.bch FAILED with STATUS 2830 (0 is normal). Elapsed time = 609(609) seconds.
3/11/2015 9:24:02 AM - Info dbclient(pid=872) INF - Results of executing <C:\Users\access\Desktop\Restore1.bch>:       
3/11/2015 9:24:02 AM - Info dbclient(pid=872) <0> operations succeeded. <1> operations failed.    

[RamNagalla]

3/11/2015 9:19:09 AM - restored image dzorrpw24_1423350026 - (Restore failed due to an incorrect path in MS-SQL-Server MOVE script(2830)); restore time 0:02:18

please post the script that you are using for restore..

[mohamed_souidi]

#  
#  This is a template for the database MOVE command.
#  
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
#  
#  Replace the database name in the following line with the name of the database that you
#  want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
#  
DATABASE "AMOS2"
# 
#  Replace the file path <H:\Amos2 DB\AMOS2.mdf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "amos2". 
MOVE  "amos2"
TO  "E:\Amos2DB\AMOS2.mdf"
# 
# 
#  Replace the file path <H:\Amos2 DB\AMOS2_log.ldf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "amos2_log". 
MOVE  "amos2_log"
TO  "E:\Amos2DB\AMOS2_log.ldf"
# 
# The following image is type: Full
NBIMAGE "DZORRPW24.MSSQL7.DZORRPW24.db.AMOS2.~.7.001of001.20150208000011..C"
SQLHOST "DZORVPW83"
NBSERVER "DZORRPW28.INTRANET.HYPROC"
BROWSECLIENT "10.42.1.24"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE NOTRECOVERED
NUMBUFS 2
ENDOPER TRUE

OPERATION RESTORE
OBJECTTYPE TRXLOG
#  
#  Replace the database name in the following line with the name of the database that you
#  want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
#  
#DATABASE "AMOS2"
# The following image is type: transaction log
NBIMAGE "DZORRPW24.MSSQL7.DZORRPW24.trx.AMOS2.~.7.001of001.20150208130007..C"
SQLHOST "DZORVPW83"
NBSERVER "DZORRPW28.INTRANET.HYPROC"
BROWSECLIENT "10.42.1.24"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

[Marianne]

Have you confirmed that folder E:\Amos2DB\ exist? 
and writable by the user performing the restore?

[mohamed_souidi]

yes the folder in the patch E:\Amos2DB\ exist and writable.

[Michael_G_Ander]

Looking at the script, shouldn't the hashmark before the second #DATABASE entry be removed too ?

[mohamed_souidi]

#  
#  This is a template for the database MOVE command.
#  
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
#  
#  Replace the database name in the following line with the name of the database that you
#  want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
#  
DATABASE "AMOS2"
 
#  Replace the file path <H:\Amos2 DB\AMOS2.mdf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "amos2". 
MOVE  "amos2"
TO  "H:\Amos2DB\AMOS2.mdf"
 
 
#  Replace the file path <H:\Amos2 DB\AMOS2_log.ldf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "amos2_log". 
MOVE  "amos2_log"
TO  "H:\Amos2DB\AMOS2_log.ldf"
 
# The following image is type: Full
NBIMAGE "DZORRPW24.MSSQL7.DZORRPW24.db.AMOS2.~.7.001of001.20150314000016..C"
SQLHOST "DZORVPW83"
NBSERVER "DZORRPW28.INTRANET.HYPROC"
BROWSECLIENT "10.42.1.24"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

[mohamed_souidi]

#  
#  This is a template for the database MOVE command.
#  
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
#  
#  Replace the database name in the following line with the name of the database that you
#  want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
#  
DATABASE "AMOS2"
 
#  Replace the file path <H:\Amos2DB\AMOS2.mdf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "amos2". 
MOVE  "amos2"
TO  "H:\Amos2DB\AMOS2.mdf"
 
 
#  Replace the file path <H:\Amos2DB\AMOS2_log.ldf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "amos2_log". 
MOVE  "amos2_log"
TO  "H:\Amos2DB\AMOS2_log.ldf"
 
# The following image is type: Full
NBIMAGE "DZORRPW24.MSSQL7.DZORRPW24.db.AMOS2.~.7.001of001.20150314000016..C"
SQLHOST "DZORVPW83"
NBSERVER "DZORRPW28.INTRANET.HYPROC"
BROWSECLIENT "10.42.1.24"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

[Michael_G_Ander]

The last two scripts are not move scripts as the paths are not changed from the original paths.

You will probably need to change them to E:\Amos2DB\AMOS2.mdf and E:\Amos2DB\AMOS2.ldf if the E: drive is where you want the AMOS2 database on the new host