MSSQL Restore error

[Balaji_Subraman]

Dear Gurus,

I tried to restored the MSSQL database backup on the same client. but it failed with errors.

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_today.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_today.bch>: 
<0> operations succeeded. <1> operations failed.

also when i checked the windows application log, some error occured related to SQL as below.

SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=19820. Thread=19704. Client. Instance=. VD=Global\VNBU0-19820-14436-1406176593_SQLVDIMemoryName_0. 

i followed the restored procedure as mentioned in the below technote:

http://www.symantec.com/business/support/index?page=content&id=TECH35995 

Please suggest me how to proceed.

Thanks and Regards

Balaji

[RiaanBadenhorst]

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

[Marianne]

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.

[Balaji_Subraman]

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

[RiaanBadenhorst · Accepted solution]

Hi,

You didn't move LOG in the script above (its not unhashed)?

[Balaji_Subraman]

Hi Riaan,

Thanks for the help. Restored finished.

Balaji