cancel
Showing results for 
Search instead for 
Did you mean: 

sql restore failed from client

Arshad_Khateeb
Level 5
Certified

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.
1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@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)

View solution in original post

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@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)

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
Moderator
Moderator
Partner    VIP    Accredited Certified

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... *** 

finally it was found that the guy who was restoring from database side was doing wrong. he was by mistake doing restoring from different server which just has a small difference in its name. we are done with the restore today and glad it worked. i will revert the changes i have done and by the way bprdreq -rereadconfig worked instead of restarting the NetBackup daemons.

thanks Marrianne for your real quick help on this issue!