@Marianne van den Berg:
@varunprakash :
Thanks, i've tried as yours suggestion but cannot restore, the operation status : error(-1)
Process as below
#
# 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 "Test_restore"
#
# Replace the file path <..............\Test_restore.mdf>
# with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
# The target of the MOVE keyword must be "Test_restore".
MOVE "Test_restore"
#TO "...............\Test_restore.mdf"
#
#
# Replace the file path <.....................................\Test_restore_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 "Test_restore_log".
MOVE "Test_restore_log"
#TO "......................\Test_restore_log.ldf"
#
# The following image is type: Full
NBIMAGE "servername.MSSQL7.servername.db.Test_restore.~.7.001of001.20100820133218..C"
SQLHOST ".........."
NBSERVER "..........."
BROWSECLIENT "................"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE
USER - ?
INF - Results of executing <.........................\test restore.bch>:
<0> operations succeeded. <1> operations failed.
INF - The following object(s) were not backed up successfully.
INF - ?
Pru.vn