cancel
Showing results for 
Search instead for 
Did you mean: 

Netbackup activity monitor show backup successful but client shows partially successful?????

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited
I am facing suspected problem. My Veritas Netbackup shows backup restored successfully but client logs showing partially successful


My Enviroment

OS # windows2003 server
Netbackup Version # Veritas Netbackup 6.5


Activity Monitor Details

8/17/2009 6:00:26 AM - begin Restore
8/17/2009 6:00:33 AM - restoring image server-sec_1250391155
8/17/2009 6:00:33 AM - requesting resource Fibre Transport
8/17/2009 6:00:33 AM - Warning nbjm(pid=2496) NBU status: 800, EMM status: Fibre Transport resources are not available 
8/17/2009 6:00:33 AM - Warning nbjm(pid=2496) NBU status: 800, EMM status: Fibre Transport resources are not available 
8/17/2009 6:00:46 AM - connected
8/17/2009 6:00:46 AM - started process bptm (6128)
8/17/2009 6:00:46 AM - started process bptm (3604)
8/17/2009 6:00:48 AM - begin reading
8/17/2009 6:01:00 AM - restored image server-sec_1250391155 - (the requested operation was successfully completed(0)); restore time 00:00:27
8/17/2009 6:01:03 AM - end Restore; elapsed time: 00:00:37
the requested operation was successfully completed(0)


Client side details




Restore started Mon Aug 17 05:14:30 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.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]80 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]90 percent processed.>.

INF - Thread has been closed for stripe #0
INF - OPERATION #1 of batch C:\Documents and Settings\abc.xyz\Desktop\Restoration150809.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 2754(2702) seconds
INF - RESTORE STARTED USING
Microsoft SQL Server 2005 - 9.00.3200.00 (X64)
Oct  2 2007 12:23:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = C:\Documents and Settings\abc.xyz\Desktop\Restoration150809.bch, Op# = 2.
INF - Using backup image server-sec.MSSQL7.SQL-CLUSTER.inc.Dotnet111.~.7.001of001.20090816075227..C
INF - restore database "Dotnet111" from VIRTUAL_DEVICE='VNBU0-8904-7564-1250470822' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <DOTNET-SERVER>. Connection timeout is <300> seconds.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]RESTORE DATABASE is terminating abnormally.>.
DBMS MSG - SQL Message <0><[Microsoft][SQL Native Client]Unspecified error occurred on SQL Server. Connection may have been terminated by the server.>
ERR - Error found executing <restore database "Dotnet111" from VIRTUAL_DEVICE='VNBU0-8904-7564-1250470822' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery>.
ERR - Error in VDS->Close: 0x80770004.
    CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #2 of batch C:\Documents and Settings\abc.xyz\Desktop\Restoration150809.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 43(43) seconds.
INF - Results of executing <C:\Documents and Settings\abc.xyz\Desktop\Restoration150809.bch>:
<1> operations succeeded. <1> operations failed.
INF - Thread has been closed for stripe #0



9 REPLIES 9

Mouse
Moderator
Moderator
Partner    VIP    Accredited Certified

Several months ago our customer faced the same problem, but they were running SQL 2000.
Maybe you need to ask Microsoft for the latest patches for your SQL Server (this problem is out of NBU scope)

Here is technote with the same evidence

3rd PARTY: When restoring a Microsoft SQL server database using the Veritas NetBackup (tm) SQL Server agent, the restore finishes successfully, but the recovery of the database fails, and the database appears as "Suspect" in the SQL Enterprise Manager.

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited
Thanks for your input mouse :)

Mouse
Moderator
Moderator
Partner    VIP    Accredited Certified
I'll appreciate if you share the reason of this problem with us once you'll have it sorted out

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited
Actually mouse i tried to restore the backup image in the morning again and it successfully restored. what i have come to know that the .LDF file of SQL might/Must be grown enough thats why it was doing problem.

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited
In the client side View Status i faced this problem as well. is this also related to my previous problem which i have posted earlier ???
Note:- the backup restored successfully but still getting the below error
<2> operations succeeded. <0> operations failed.


-----------------------------------------------------------------------------

INF - RESTORE STARTED USING
Microsoft SQL Server 2005 - 9.00.3200.00 (X64)
Oct  2 2007 12:23:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SQL-Test.bch, Op# = 1.
INF - Using backup image dbserver-sec.MSSQL7.SQL-CLUSTER.db.ABCdotnet.~.7.001of001.20090816151513..C
INF - restore database "ABCdotnet" from VIRTUAL_DEVICE='VNBU0-4216-7860-1250495467' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'Master' to 'B:\CRITICAL-DATA11\ABCdotnet_Master.NDF', move 'GH' to 'H:\CRITICAL-DATA11\ABCdotnet_GH.NDF', move 'GL' to 'G:\CRITICAL-DATA11\ABCdotnet_GL.NDF', move 'ABCDotNet_Data' to 'R:\CRITICAL-DATA11\ABCdotnet.mdf', move 'ABCDotNet_Log' to 'T:\CRITICAL-DATA11\ABCdotnet_log.ldf', replace
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <SERVER1>. Connection timeout is <300> seconds.
Restore started Mon Aug 17 12:51:10 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.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]80 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]90 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]100 percent processed.>.
INF - SQL Message <4035><[Microsoft][SQL Native Client][SQL Server]Processed 12636800 pages for database 'ABCdotnet', file 'ABCDotNet_Data' on file 1.>
INF - SQL Message <4035><[Microsoft][SQL Native Client][SQL Server]Processed 4094944 pages for database 'ABCdotnet', file 'GTLive' on file 1.>
INF - SQL Message <4035><[Microsoft][SQL Native Client][SQL Server]Processed 8 pages for database 'ABCdotnet', file 'GTHistory' on file 1.>
INF - SQL Message <4035><[Microsoft][SQL Native Client][SQL Server]Processed 77024 pages for database 'ABCdotnet', file 'BankMaster' on file 1.>
INF - SQL Message <4035><[Microsoft][SQL Native Client][SQL Server]Processed 408 pages for database 'ABCdotnet', file 'ABCDotNet_Log' on file 1.>

INF - Thread has been closed for stripe #0
INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SQL-Test.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 1827(1779) seconds
INF - RESTORE STARTED USING
Microsoft SQL Server 2005 - 9.00.3200.00 (X64)
Oct  2 2007 12:23:02
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SQL-Test.bch, Op# = 2.
INF - Using backup image dbserver-sec.MSSQL7.SQL-CLUSTER.inc.ABCdotnet.~.7.001of001.20090816220259..C
INF - restore database "ABCdotnet" from VIRTUAL_DEVICE='VNBU0-4216-6888-1250497297' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <SERVER1>. Connection timeout is <300> seconds.
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 - SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]30 percent processed.>
INF - 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 - SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]60 percent processed.>
INF - SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]70 percent processed.>
INF - SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]80 percent processed.>
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]90 percent processed.>.
INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][SQL Native Client][SQL Server]100 percent processed.>.
INF - SQL Message <4035><[Microsoft][SQL Native Client][SQL Server]Processed 123568 pages for database 'ABCdotnet', file 'ABCDotNet_Data' on file 1.>
INF - SQL Message <4035><[Microsoft][SQL Native Client][SQL Server]Processed 2816 pages for database 'ABCdotnet', file 'GTLive' on file 1.>
INF - SQL Message <4035><[Microsoft][SQL Native Client][SQL Server]Processed 8 pages for database 'ABCdotnet', file 'GTHistory' on file 1.>
INF - SQL Message <4035><[Microsoft][SQL Native Client][SQL Server]Processed 11640 pages for database 'ABCdotnet', file 'BankMaster' on file 1.>
INF - SQL Message <4035><[Microsoft][SQL Native Client][SQL Server]Processed 30 pages for database 'ABCdotnet', file 'ABCDotNet_Log' on file 1.>
INF - Thread has been closed for stripe #0
INF - restore database "ABCdotnet" with recovery
INF - Recovered database ABCdotnet with STATUS 0 (0 is normal)
INF - OPERATION #2 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SQL-Test.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 125(57) seconds
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SQL-Test.bch>:
<2> operations succeeded. <0> operations failed.

 


Mouse
Moderator
Moderator
Partner    VIP    Accredited Certified
There are no any failed operations in this log. What is your question about?

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited
in the last line

<2> operations succeeded. <0> operations failed.

what does it mean     <2> operations succeeded.  ????


Thanks for your kind reply Mouse

Mouse
Moderator
Moderator
Partner    VIP    Accredited Certified
This is quite simple
You have two operations in the batch - first is a retrieval of a database from the backup and second is a recovery. So, both operations were sucessful, that is what this string means

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited
Ahhh !!!! Thanks :)