cancel
Showing results for 
Search instead for 
Did you mean: 

An attempt to restore BD on another target server

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.      

 

 

 

1 Solution

Accepted Solutions
Accepted Solution!

Hi, started the restore from

Hi,

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

 

Regards,

View solution in original post

3 Replies

hope , you have followed the

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

 

Please share all the steps

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. 

Accepted Solution!

Hi, started the restore from

Hi,

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

 

Regards,

View solution in original post