1.
https://www-secure.symantec.com/connect/forums/restore-sql-transaction-log-along-database-different-sql-server#comment-10317631.
Where did you try to start the restore?
It must be done on the destination client where you want to restore to.
You first have to authorize redirected restore on the master by creating altnames files or else No.Restrictions touch file.
See 'Redirecting a restore to a different host' in NetBackup for Microsoft SQL Server Administrator's Guide: http://www.symantec.com/docs/DOC5173
Please also ensure that you have NBU 7.5.0.5 or later installed on the SQL servers - there were bugs/issues with erlier 7.5 patch levels.
https://www-secure.symantec.com/connect/forums/netbackup-sql-restore-different-hostpath-and-instance#comment-9697891
Log on to the server where you want to restore (SAOS00506006) and run it from there.
BROWSECLIENT 'Restores images from a host other than the local host.'
so it must point to the original server
also change
TO "F:\MSSQL\DataATLAS_log.ldf"
to
TO "F:\MSSQL\Data\ATLAS_log.ldf"
(missing backslash)
and make sure the path F:\MSSQL\Data\ exists on SAOS00506006
Will Restore -- where there is a Will there is a way
2.https://www-secure.symantec.com/connect/forums/regarding-sql-restore#comment-9162871
...my Source SQL server is on 2008 version and Destination SQL Server is on 2005 version .....
I cannot imagine that this will be supported by Microsoft. Probably the reason for the error we see in above output:
https://www-secure.symantec.com/connect/forums/netbackup-cannot-browse-or-restore-sql-client-backups#comment-9687851
When you browse for restores, the SQL server will send its local hostname as Source Client to the master.
When you modify the hostname in the SQL Client GUI to the Virtual name, it sends the following to the master server:
Client ETCCSPCLDB2 is requesting backup images for Client ETCCSPCLDB.
The master treats these names as totally different Client names (i.e. redirected restore).
Now, in NBU, client restore of a different client name is not allowed by default.
You need to add altnames files to allow client to perform redirected restore.
All of this is documented in NBU for SQL Admin Guide: http://www.symantec.com/docs/DOC5173
See Redirecting a restore to a different host
and Performing a restore on a virtual SQL Server instance
Hope this helps.