Forum Discussion

Arshad_Khateeb's avatar
5 years ago

sql restore failed from client

Master 

serverALinux(2.6.32-754.25.1.el6.x86_64)UNIXMaster Server8.1ConnectedOff

 

Client

usseccmpsqce110.ey.netWindows2012(6)WindowsClient7.7.3Connected

Off

 

Error 

 
INF - RESTORE STARTED USING
Microsoft SQL Server 2012 (SP4-GDR) (KB4057116) - 11.0.7462.6 (X64)
Jan  5 2018 22:11:56
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )
Batch = C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\Statestics.bch, Op# = 1.
INF - Using backup image USSECBMPSQCE210.MSSQL7.USSECCMPSQCE210\INST2.db.Statistics_DB.~.7.001of001.20200201010322..C
INF - restore database "Statistics_DB_feb" from VIRTUAL_DEVICE='VNBU0-7840-17592-1586278024' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'Statistics_DB' to 'G:\G_SQLDATA_1\SQLDATA\Statistics_DB_feb.mdf', move 'Statistics_DB_log' to 'G:\G_SQLLOG_1\SQLLOG\Statistics_DB_Feblog.ldf'
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <INST2>. Connection timeout is <900> seconds.
ERR - Error in GetConfiguration: 0x80770003.
    CONTINUATION: - The api was waiting and the timeout interval had elapsed.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3201><[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open backup device 'VNBU0-7840-17592-1586278024'. Operating system error 0x80070002(The system cannot find the file specified.).>.
DBMS MSG - SQL Message <3013><[Microsoft][SQL Server Native Client 11.0][SQL Server]RESTORE DATABASE is terminating abnormally.>
ERR - Error found executing <restore database "Statistics_DB_feb" from VIRTUAL_DEVICE='VNBU0-7840-17592-1586278024' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'Statistics_DB' to 'G:\G_SQLDATA_1\SQLDATA\Statistics_DB_feb.mdf', move 'Statistics_DB_log' to 'G:\G_SQLLOG_1\SQLLOG\Statistics_DB_Feblog.ldf'>.
INF - OPERATION #1 of batch C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\Statestics.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 906(906) seconds.
INF - Results of executing <C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\Statestics.bch>:
<0> operations succeeded. <2> operations failed.
  • Arshad_Khateeb 

    What is the size of the database? 

    Always good to increase Client Read timeout on media server before a restore is attempted (the manual says the value must be changed on the client) :

    About minimizing timeout failures on large SQL Server database restores
    A large SQL Server restore may fail with a Client Read Timeout error before any
    data has been read from the NetBackup media. This error occurs because the SQL
    Server may need to pre-write the database files before the restore operation begins.
    The time that is required for this process is a function of certain factors: the size of
    the database files and the speed at which your host machine can write to disk. For
    example, consider that your system can perform disk writes at the rate of 60
    megabytes per second and you have a 2.4 terabyte database. Then it takes at least
    12 hours for SQL Server to prep the disk before the actual restore can begin. In
    reality, the delay may be even longer than what you calculate by as much as 20%
    to 40%.
    The timeout problem can be resolved by increasing the NetBackup Client Read
    Timeout setting. Use the NetBackup Administration Console on the server to change
    the properties of each client that contains a database you may need to restore. 

    You may also want to look at this section in the manual: 

    Instant data file initialization
    When you restore a database, filegroup, or database file, SQL Server zeroes the
    file space before it begins the restore operation. This action can slow the total
    recovery time by as much as a factor of 2. To eliminate file initialization, run the
    MSSQLSERVER service under a Windows account that has been assigned the
    SE_MANAGE_VOLUME_NAME. For more information, see the SQL Server and
    the Windows documentation.

    For further troubleshooting, please ensure that the following log folders exist:

    On client - dbclient  (Set logging level to 3. )
    On media server: bpbrm and bptm
    On master: bprd  (NBU needs to be restarted after this folder is created)

  • Arshad_Khateeb 

    What is the size of the database? 

    Always good to increase Client Read timeout on media server before a restore is attempted (the manual says the value must be changed on the client) :

    About minimizing timeout failures on large SQL Server database restores
    A large SQL Server restore may fail with a Client Read Timeout error before any
    data has been read from the NetBackup media. This error occurs because the SQL
    Server may need to pre-write the database files before the restore operation begins.
    The time that is required for this process is a function of certain factors: the size of
    the database files and the speed at which your host machine can write to disk. For
    example, consider that your system can perform disk writes at the rate of 60
    megabytes per second and you have a 2.4 terabyte database. Then it takes at least
    12 hours for SQL Server to prep the disk before the actual restore can begin. In
    reality, the delay may be even longer than what you calculate by as much as 20%
    to 40%.
    The timeout problem can be resolved by increasing the NetBackup Client Read
    Timeout setting. Use the NetBackup Administration Console on the server to change
    the properties of each client that contains a database you may need to restore. 

    You may also want to look at this section in the manual: 

    Instant data file initialization
    When you restore a database, filegroup, or database file, SQL Server zeroes the
    file space before it begins the restore operation. This action can slow the total
    recovery time by as much as a factor of 2. To eliminate file initialization, run the
    MSSQLSERVER service under a Windows account that has been assigned the
    SE_MANAGE_VOLUME_NAME. For more information, see the SQL Server and
    the Windows documentation.

    For further troubleshooting, please ensure that the following log folders exist:

    On client - dbclient  (Set logging level to 3. )
    On media server: bpbrm and bptm
    On master: bprd  (NBU needs to be restarted after this folder is created)

    • Arshad_Khateeb's avatar
      Arshad_Khateeb
      Level 5
      Thanks Marrianne for the quick response. Hope you are good with family in this pandemic.
       
      Size of the database is 1539 MB.
      On media server> client connect/read timeout-14400, backup start/end notify timeout-300
      on client> dbcilent created and global loggin on it is set to 3, client read timeout set to 14400 from 300,
      on media server> global logging set to 3 from minimum, bpbrm and bptm created,
      on master> bprd exists,
      I can't restart nbu at the moment, does bprdreq -rereadconfig on master will do instead?
      Is there anything else you want me to do before i ask the SQL guys to kick off the restore?
      Thanks again!
      • Marianne's avatar
        Marianne
        Level 6

        Not 100% sure, but bprdreq -rereadconfig probably worth a try.
        dbclient will be the most useful log if the restore should fail again.

        Other than increasing timeouts, can you ask the SQL dba to look into Instant data file initialization ?

        If anything goes wrong and you want to upload logs, please copy to .txt files (e.g. dbclient.txt) and upload as attachment.
        (Seems VOX spam filter does not 'like' log output as part of a post.)

         

        *** Thanks for good wishes with pandemic.... We are healthy, thanks! Just tired of staying home during lockdown... ***