06-10-2011 11:17 PM
Alert Raised on: June 4, 2011 1:39 PM
Job: 17994
Tree Type : Server
Nodes : netbackup
Job Policy:
Exit Status: 5 (the restore failed to recover the requested files)
Client: crm-db1.trakker.com.pk
New State: Done
Alert Policy: Restore_Alert
OpsCenter Server: NETBACKUP
Severity: Warning
ERR - Error in GetCommand: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3234><[Microsoft][ODBC SQL Server Driver][SQL Server]Logical file 'ftrow_Article_2' is not part of database 'TPLTHI'. Use RESTORE FILELISTONLY to list the logical file names.>.
DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally.>
ERR - Error found executing <restore database "TPLTHI" from VIRTUAL_DEVICE='VNBU0-3760-5768-1307086072' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'TPL_PRI' to 'N:\TPL\TPL.mdf', move 'TPL_PRI_2' to 'N:\TPL\TPL_PRI_2.ndf', move 'TPL_PRI_3' to 'N:\TPL\TPL_PRI_3.ndf', move 'TPL_PRI_4' to 'N:\TPL\TPL_PRI_4.ndf', move 'TPL_IDX' to 'N:\tpl\TPL_1.ndf', move 'TPL_IDX_2' to 'N:\TPL\TPL_IDX_2.ndf', move 'TPL_SEC' to 'N:\TPL\TPL_2.ndf', move 'TPL_IDX_SECC' to 'N:\tpl\TPL_3.ndf', move 'TPL_IDX_SECC_2' to 'N:\TPL\TPL_IDX_SECC_2.ndf', move 'TPL_IDX_SEC3' to 'N:\tpl\TPL_IDX_SEC3.ndf', move 'TPL_IDX_SEC4' to 'N:\TPL\TPL_IDX_SEC4.ndf', move 'ftrow_Article' to 'N:\tpl\ftrow_Article.ndf', move 'ftrow_Article_2' to 'N:\TPL\ftrow_Article_2.ndf', move 'TPL_IDX_PRI_2' to 'N:\TPL\TPL_IDX_PRI_2.ndf', move 'TPL_IDX_PRI_1' to 'N:\TPL\TPL_IDX_PRI_1.ndf', move 'TPL_IDX_2_1' to 'N:\TPL\TPL_IDX_2_1.ndf', move 'TPL_IDX_2_2' to 'N:\TPL\TPL_IDX_2_2.ndf', move 'TPL_log' to 'N:\tpl\TPL_4.ldf', move 'TPL_log2' to 'N:\tpl\TPL_log2.ldf', move 'TPL_log3' to 'N:\tpl\TPL_log3.ldf', replace>.
06-11-2011 12:05 AM
Please let us know what exactly was done.
Is this a restore to the same or alternate client? Where was the restore initiated from? Have you ensured sufficient Client Read Timeout? Was the GUI used to select databases for restore? Was GUI used to save move template and modified afterwards? Have a look at this error:
"Logical file 'ftrow_Article_2' is not part of database 'TPLTHI'. Use RESTORE FILELISTONLY to list the logical file names."
Do you have dbclient log on the destination client? If so, please post the log as an attachment.
Have a look at this O-L-D (but still relevant) TN for troubleshooting SQL restore problems: http://www.symantec.com/docs/TECH39006
Please also let us know all relevant version info: NBU version on master, media and client, SQL version, OS versions.
06-11-2011 01:24 AM
Actually this error is caused by a number of issues
Have a look at these technotes, perhaps one of them matches your case
http://www.symantec.com/business/support/index?page=answers&startover=y&question_box=ERR+-+Error+in+GetCommand%3A+0x80770004&myclicker.x=0&myclicker.y=0
My best bet is to disable sriping and to increase CLIENT_READ_TIMEOUT on the media server that is used for restore.
06-12-2011 04:04 AM
Hi,
The error you have sounds like there is problems with the move script. Make sure you only has out the database line and the to lines and change the path, do not change anything else.
See technote
http://www.symantec.com/business/support/index?page=content&id=TECH18781
/Oddy