Forum Discussion

Zahid_Haseeb's avatar
Zahid_Haseeb
Moderator
16 years ago

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

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



7.1.x and Earlier
Backup and Recovery
NetBackup

9 Replies

Sort By
  • Mouse's avatar
    Mouse
    Moderator
    16 years ago

    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.

  • Mouse's avatar
    Mouse
    Moderator
    16 years ago
    I'll appreciate if you share the reason of this problem with us once you'll have it sorted out
  • Zahid_Haseeb's avatar
    Zahid_Haseeb
    Moderator
    16 years ago
    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's avatar
    Zahid_Haseeb
    Moderator
    16 years ago
    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's avatar
    Mouse
    Moderator
    16 years ago
    There are no any failed operations in this log. What is your question about?
  • Zahid_Haseeb's avatar
    Zahid_Haseeb
    Moderator
    16 years ago
    in the last line

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

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


    Thanks for your kind reply Mouse
  • Mouse's avatar
    Mouse
    Moderator
    16 years ago
    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