Forum Discussion

Zahid_Haseeb's avatar
Zahid_Haseeb
Moderator
16 years ago
Solved

SQL restore is failed with status code 85

i am facing restore failed while restoring the SQL backup via Netbackup 6.5, Operating System 2003 32bit, the drive on which backup exist is SAN drive and connected via fiber channel with Netbackup Server

Activity Monitor status;



6/16/2009 9:06:43 AM - begin Restore

6/16/2009 9:06:50 AM - restoring image dbcluster_1244927104

6/16/2009 9:06:50 AM - requesting resource Fibre Transport

6/16/2009 9:06:50 AM - Warning nbjm(pid=2524) NBU status: 800, EMM status: Fibre Transport resources are not available

6/16/2009 9:06:50 AM - Warning nbjm(pid=2524) NBU status: 800, EMM status: Fibre Transport resources are not available

6/16/2009 9:07:06 AM - connected

6/16/2009 9:07:06 AM - started process bptm (9128)

6/16/2009 9:07:06 AM - started process bptm (8512)

6/16/2009 9:07:08 AM - begin reading

6/16/2009 11:31:14 AM - Critical bptm(pid=9128) sts_read_image failed: error 2060017 system call failed

6/16/2009 11:31:14 AM - Critical bptm(pid=9128) image read failed: error 2060017: system call failed

6/16/2009 11:31:14 AM - Error bptm(pid=9128) cannot read image from disk, Invalid argument

6/16/2009 11:31:16 AM - Error bptm(pid=8512) The following files/folders were not restored:

6/16/2009 11:31:16 AM - Error bptm(pid=8512) UTF - /dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

6/16/2009 11:31:16 AM - Error bptm(pid=8512) UTF - /dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

6/16/2009 11:31:16 AM - Error bptm(pid=8512) UTF - /dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

6/16/2009 11:31:16 AM - Error bptm(pid=8512) UTF - /dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

6/16/2009 11:31:17 AM - Error bptm(pid=8512) UTF - /dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

6/16/2009 11:31:17 AM - Error bptm(pid=8512) UTF - /dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

6/16/2009 11:31:17 AM - Error bptm(pid=8512) UTF - /dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

6/16/2009 11:31:17 AM - Error bptm(pid=8512) UTF - /dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

6/16/2009 11:31:17 AM - Error bptm(pid=8512) UTF - /dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

6/16/2009 11:31:17 AM - Error bptm(pid=8512) UTF - /dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

6/16/2009 11:31:17 AM - Error bptm(pid=8512) more than 10 files were not restored, remaining ones are shown in the progress log.

6/16/2009 11:31:19 AM - restored image dbcluster_1244927104 - (media read error(85)); restore time 02:24:29

6/16/2009 11:31:22 AM - Error bpbrm(pid=8660) client restore EXIT STATUS 85: media read error

6/16/2009 11:31:23 AM - end Restore; elapsed time: 02:24:40

the restore failed to recover the requested files(5)


At client side


INF - RESTORE STARTED USING

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)

Feb 9 2007 22:47:07

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Batch = C:\Documents and Settings\Administrator\Desktop\Sona_Pay_Roll.bch, Op# = 1.

INF - Using backup image dbcluster-sec.MSSQL7.DBCLUSTER.db.Sonawaredotnet.~.7.001of001.20090614020455..C

INF - restore database "SonaPayRoll-1" from VIRTUAL_DEVICE='VNBU0-6040-4048-1245071971' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'BankMaster' to 'i:\Test-DATA\Sonawaredotnet_BankMaster.NDF', move 'GTHistory' to 'i:\Test-DATA\Sonawaredotnet_GT_History.NDF', move 'GTLive' to 'i:\Test-DATA\Sonawaredotnet_GT_Live.NDF', move 'SonaDotNet_Data' to 'i:\Test-Data\Sonawaredotnet.mdf', move 'SonaDotNet_Log' to 'i:\Test-Data\Sonawaredotnet_1.ldf', replace

INF - Number of stripes: 1, Number of buffers per stripe 2.

INF - Created VDI object for SQL Server instance <dotnet-reptg>. Connection timeout is <300> seconds.

Restore started Mon Jun 15 18:19:32 2009



INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]10 percent processed.>.

INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]20 percent processed.>.

INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]30 percent processed.>.

INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]40 percent processed.>.

INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]50 percent processed.>.

INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]60 percent processed.>.

INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]70 percent processed.>.

ERR - Error in VxBSAGetData: 3.

CONTINUATION: - System detected error, operation aborted.

ERR - Error in DBthreads::dbclient: 6.

CONTINUATION: - The system cannot find the file specified.

ERR - Error in VxBSAEndData: 6.

CONTINUATION: - The handle used to associate this call with a previous VxBSAInit() call is invalid.



ERR - Error in VDS->Close: 0x80770004.

CONTINUATION: - An abort request is preventing anything except termination actions.

INF - OPERATION #1 of batch C:\Documents and Settings\Administrator\Desktop\Sona_Pay_Roll.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 8176(0) seconds.

INF - Results of executing <C:\Documents and Settings\Administrator\Desktop\Sona_Pay_Roll.bch>:

<0> operations succeeded. <1> operations failed.


  • Problem has been resolved
    1st of all i am very very thankful to all guys who given me so kind support
    My database which i was trying to restore was about 120GB of size and the drive had around 188 GB free space.
    I though that the Netbackup need more space might be for buffering etc so I just got free some more disk space and eventually the restoration has been completed successfully

11 Replies