@varunprakash : Thanks
I've tried but there are errors, and on activity monitor, could not found any restore database job.
If you have any document or link instruction restore database, Could you pls give me for clearly ?
Thanks
The Log file as below
# This batch file was created for an operation on host SMSSDBS01 using
# the SQL Server instance <default>.
# Move this file to the Veritas\NetBackup\dbext\MSSQL\ directory
# on host <........>. Execute it there using the NetBackup
# Database Extension GUI or the NetBackup Scheduler.
#
#
# 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 <C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\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 "D:\New Folder\test_restore.mdf"
#
#
# Replace the file path <C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\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 "D:\New Folder\test_restore_log.ldf"
#
# The following image is type: Full
NBIMAGE "..........MSSQL7.................db.test_restore.~.7.001of001.20100823094758..C"
SQLHOST ".............."
NBSERVER "..............."
BROWSECLIENT "............"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE
INF - RESTORE STARTED USING
Microsoft SQL Server 2005 - 9.00.4028.00 (Intel X86)
Oct 20 2008 19:45:04
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 6.0 (Build 6001: Service Pack 1)
Batch = C:\Users\............\Desktop\new test.bch, Op# = 1.
INF - Using backup image ..........4.MSSQL7..............4.db.test_restore.~.7.001of001.20100823094758..C
INF - restore database "test_restore" from VIRTUAL_DEVICE='VNBU0-7096-9128-1282534729' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'test_restore' to 'D:\New Folder\test_restore.mdf', move 'test_restore_log' to 'D:\New Folder\test_restore_log.ldf', replace
INF - Number of stripes: 1, Number of buffers per stripe 2.
ERR - Error in CoCreateInstance: 0x80040154.
CONTINUATION: - An attempt was made to reference a token that does not exist.
INF - OPERATION #1 of batch C:\Users\...............\Desktop\new test.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 3(3) seconds.
INF - Results of executing <C:\Users\..............\Desktop\new test.bch>:
<0> operations succeeded. <1> operations failed.