MSSQL Restore error

Did you move it to a different location? Why did you use a move script?

For a normal restore follow http://www.symantec.com/docs/HOWTO85250

Did the restore job show up in Activity Monitor?

If so, please show us all text in Details tab.

If not, double-check that redirected restore is allowed.
Verify that Windows Explorer did not add .txt to No.Restrictions file.

Check that Client Read Timeout on media server is increased to give SQL time to initialize databases before actual restore can be started. Set it to 3 hours (10800) to prevent timeouts.

Next, ensure that logging is enabled. Create the following log folders under ...\netbackup\logs:

On master: bprd
(Restart NBU Request Service to enable this log)

On destination SQL client: dbclient

After next failure, please copy logs to .txt files (e.g. bprd.txt) and upload as File attachments.

Hi Riaan,

Thanks for help, now normal restore can completed successfully (it replaced the database).

but when i tried to restore the database in different name in the same host, i got the error.

error log 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 "SRM_NEW_TEST"
#
#  Replace the file path <D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SRM_NEW.mdf>
#  with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
#  The target of the MOVE keyword must be "SRM_NEW".
MOVE  "SRM_NEW"
TO  "D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SRM_NEW_TEST.mdf"
#
#
#  Replace the file path <D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SRM_NEW_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 "SRM_NEW_log".
#MOVE  "SRM_NEW_log"
#TO  "D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SRM_NEW_log.ldf"
#
# The following image is type: Full
NBIMAGE "thsvcenter.MSSQL7.THSVCENTER.db.SRM_NEW.~.7.001of001.20140725120721..C"
SQLHOST "thsvcenter"
NBSERVER "THSSYMBKP."
BROWSECLIENT "thsvcenter"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

INF - RESTORE STARTED USING
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Restore_SRM.bch, Op# = 1.
INF - Using backup image thsvcenter.MSSQL7.THSVCENTER.db.SRM_NEW.~.7.001of001.20140725120721..C
INF - restore database "SRM_NEW_TEST" from VIRTUAL_DEVICE='VNBU0-19652-13816-1406271115' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'SRM_NEW' to 'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\SRM_NEW_TEST.mdf', replace
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <thsvcenter>. Connection timeout is <300> seconds.
Restore started Fri Jul 25 12:21:56 2014

ERR - Error in GetCommand: 0x80770004.
    CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Restore_SRM.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 12(12) seconds.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Restore_SRM.bch>:
<0> operations succeeded. <1> operations failed.

---------------------------------------------------------------------------------------------------------------------------------------------------

Thanks

Balaji

Hi Riaan,

Thanks for the help. Restored finished.

Balaji