Redirect SQL restore fail with status 5 and 2850

Hi P_Kesavan,

1. The restore script on the destination SQL Host and triggered from there ? Yes. 

2. Have you created the No.restrictions file master server as you are doing the altertnate restore ?

No.Restriction file path --> \Program Files\Veritas\Netbackup\db\altnames\

Yes.

Follow the restore script on destionation SQL Server that I using:

#
# 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 "Sharepoint_Portal_CMT1109"
#
# Replace the file path <E:\MSSQL11.MSSQLSERVER\MSSQL\DATA\Sharepoint_Portal_CMT.mdf>
# with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
# The target of the MOVE keyword must be "Sharepoint_Portal_CMT".
MOVE "Sharepoint_Portal_CMT"
TO "C:\TEMP\netbackup_sql\Sharepoint_Portal_CMT1109.mdf"
#
#
# Replace the file path <F:\Rbs_CMT>
# with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
# The target of the MOVE keyword must be "RBSFilestreamFile".
MOVEFILESTREAMDIR "RBSFilestreamFile"
TO "C:\TEMP\netbackup_sql\Rbs_CMT"
#
#
# Replace the file path <F:\Log\Sharepoint_Portal_CMT_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 "Sharepoint_Portal_CMT_log".
MOVE "Sharepoint_Portal_CMT_log"
TO "C:\TEMP\netbackup_sql\Sharepoint_Portal_CMT_log1109.ldf"
#
# The following image is type: Full
NBIMAGE "elnbsbsrv42.MSSQL7.ELNBSBSRV42.db.Sharepoint_Portal_CMT.~.7.001of002.20170911204939..C"
SQLHOST "ELNBSBSRV42T"
NBSERVER "ELNBSBSRV83"
BROWSECLIENT "ELNBSBSRV42"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RECOVEREDSTATE NOTRECOVERED
NUMBUFS 2
ENDOPER TRUE

note: I was tried RECOVEREDSTATE with both RECOVERED ou NOTRECOVERED

Thanks man.