An attempt to restore BD on another target server

[Fernando_Sampai]

An attempt to restore BD on another target server

Job Details:

4/1/2015 1:07:06 PM - begin Restore
4/1/2015 1:07:07 PM - Info dbclient(pid=27396) INF - RESTORE STARTED USING       
4/1/2015 1:07:07 PM - Info dbclient(pid=27396) Microsoft SQL Server 2012 - 11.0.5532.0 (X64)     
4/1/2015 1:07:07 PM - Info dbclient(pid=27396) Jul 14 2014 15:00:27        
4/1/2015 1:07:07 PM - Info dbclient(pid=27396) Copyright (c) Microsoft Corporation        
4/1/2015 1:07:07 PM - Info dbclient(pid=27396) Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
4/1/2015 1:07:07 PM - Info dbclient(pid=27396) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SCRIPTS_RESTORE\RESTORE_FULL_TST01.bch, Op# = 1.     
4/1/2015 1:07:07 PM - Info dbclient(pid=27396) INF - Using backup image SRV10908.MSSQL7.SRVHML01\HML01.db.NETBACKUP_HOMOLOG01.~.7.001of001.20150401082130..C      
4/1/2015 1:07:07 PM - Info dbclient(pid=27396) INF - Number of stripes: 1, Number of buffers per stripe 2.
4/1/2015 1:07:08 PM - Info dbclient(pid=27396) INF - Created VDI object for SQL Server instance <TST01>. Connection timeout is <300> seconds.
4/1/2015 1:12:10 PM - Info dbclient(pid=27396) ERR - Error in GetConfiguration: 0x80770003.      
4/1/2015 1:12:10 PM - Info dbclient(pid=27396)     CONTINUATION: - The api was waiting and the timeout interval had elapsed.
4/1/2015 1:12:11 PM - Info dbclient(pid=27396) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3201><[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'VNBU0-27396-26380-1427904427'. Operating system error 0x80070002(The system cannot find the file specified.).>.
4/1/2015 1:12:11 PM - Info dbclient(pid=27396) DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally.>
4/1/2015 1:12:19 PM - Info dbclient(pid=27396) ERR - Error in VDS->Close: 0x80770004.      
4/1/2015 1:12:19 PM - Info dbclient(pid=27396)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/1/2015 1:12:19 PM - Info dbclient(pid=27396) INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SCRIPTS_RESTORE\RESTORE_FULL_TST01.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 314(314) seconds.
4/1/2015 1:12:21 PM - Info dbclient(pid=27396) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SCRIPTS_RESTORE\RESTORE_FULL_TST01.bch>:     
4/1/2015 1:12:21 PM - Info dbclient(pid=27396) <0> operations succeeded. <1> operations failed.      

[NBU35]

hope , you have followed the following document for alternate server restore with move template.

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

Please check event logs in event viewer on target server, check if there is any SQLVDI & MSSQL server related error.

If SQLVDI errors are there, then check with DBA team.

also post dbclient client logs by setting verbosity to 9 for database .. BAR> FILE> netbackup Client properties> troubleshooting

[Marianne]

Please share all the steps that were taken to perform redirected restore?

Also share the restore script (copy to .txt and upload).

I see the following error that does not look like a NBU error:

Dbbackrec::CreateSQLcmdSyntax: INF - WideCharToMultiByte failed with error 122

I cannot find any Symantec reference to 'WideCharToMultiByte ' error.

There is also the possibility of a timeout - there is each time a 5 minute gap between start of restore and the failure.
Increase Client Read Timeout on the media server. For large databases a timeout of about 3 hours (7200) is normally fine. 

[Fernando_Sampai · Accepted solution]

Hi,

started the restore from the target server and the same has been completed successfully!

Regards,