cancel
Showing results for 
Search instead for 
Did you mean: 

ERR - Error in GetConfiguration: 0x80770003

cprajput
Level 2

MS SQL 2008R2 retore failed every time.

========================================================

Nov 5, 2019 4:51:00 PM - begin Restore
Nov 5, 2019 4:51:02 PM - Info dbclient (pid=5584) INF - RESTORE STARTED USING
Nov 5, 2019 4:51:02 PM - Info dbclient (pid=5584) Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64)
Nov 5, 2019 4:51:02 PM - Info dbclient (pid=5584) Dec 28 2017 15:03:48
Nov 5, 2019 4:51:02 PM - Info dbclient (pid=5584) Copyright (c) Microsoft Corporation
Nov 5, 2019 4:51:02 PM - Info dbclient (pid=5584) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Nov 5, 2019 4:51:02 PM - Info dbclient (pid=5584) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\logi.bch, Op# = 1.
Nov 5, 2019 4:51:04 PM - Info dbclient (pid=5584) INF - Using backup image HPPKLDB03.MSSQL7.HPPKLSQLCL02.db.Logistics.~.7.001of001.20191031084659..C
Nov 5, 2019 4:51:04 PM - Info dbclient (pid=5584) INF - restore database "Logistics" from VIRTUAL_DEVICE='VNBU0-5584-8452-1572952862' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'Logistics' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Logistics.mdf', move 'Logistics_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Logistics_log.ldf'
Nov 5, 2019 4:51:05 PM - Info dbclient (pid=5584) INF - Number of stripes: 1, Number of buffers per stripe 2.
Nov 5, 2019 4:51:07 PM - Info dbclient (pid=5584) INF - Created VDI object for SQL Server instance <HPPKLSQLCL01>. Connection timeout is <300> seconds.
Nov 5, 2019 4:56:12 PM - Info dbclient (pid=5584) ERR - Error in GetConfiguration: 0x80770003.
Nov 5, 2019 4:56:13 PM - Info dbclient (pid=5584) CONTINUATION: - The api was waiting and the timeout interval had elapsed.
Nov 5, 2019 4:56:15 PM - Info dbclient (pid=5584) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3201><[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open backup device 'VNBU0-5584-8452-1572952862'. Operating system error 0x80070002(The system cannot find the file specified.).>.
Nov 5, 2019 4:56:16 PM - Info dbclient (pid=5584) DBMS MSG - SQL Message <3013><[Microsoft][SQL Server Native Client 10.0][SQL Server]RESTORE DATABASE is terminating abnormally.>
Nov 5, 2019 4:56:17 PM - Info dbclient (pid=5584) ERR - Error found executing <restore database "Logistics" from VIRTUAL_DEVICE='VNBU0-5584-8452-1572952862' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'Logistics' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Logistics.mdf', move 'Logistics_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Logistics_log.ldf'>.
Nov 5, 2019 4:56:24 PM - Info dbclient (pid=5584) INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\logi.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 323(323) seconds.
Nov 5, 2019 4:56:27 PM - Info dbclient (pid=5584) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\logi.bch>:
Nov 5, 2019 4:56:27 PM - Info dbclient (pid=5584) <0> operations succeeded. <2> operations failed.

===========================================================

5 REPLIES 5

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

The dbclient log does not match the Job Details.

We need to see details of PID 5584.

Please also confirm that client logging level is minimum of 3. 

cprajput
Level 2

Thanks for quick reply.........

Nov 5, 2019 5:57:24 PM - begin Restore
Nov 5, 2019 5:57:26 PM - Info dbclient (pid=6384) INF - RESTORE STARTED USING
Nov 5, 2019 5:57:26 PM - Info dbclient (pid=6384) Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64)
Nov 5, 2019 5:57:26 PM - Info dbclient (pid=6384) Dec 28 2017 15:03:48
Nov 5, 2019 5:57:26 PM - Info dbclient (pid=6384) Copyright (c) Microsoft Corporation
Nov 5, 2019 5:57:26 PM - Info dbclient (pid=6384) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Nov 5, 2019 5:57:26 PM - Info dbclient (pid=6384) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\logi.bch, Op# = 1.
Nov 5, 2019 5:57:27 PM - Info dbclient (pid=6384) INF - Using backup image HPPKLDB03.MSSQL7.HPPKLSQLCL02.db.Logistics.~.7.001of001.20191031084659..C
Nov 5, 2019 5:57:28 PM - Info dbclient (pid=6384) INF - restore database "Logistics" from VIRTUAL_DEVICE='VNBU0-6384-6120-1572956846' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'Logistics' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Logistics.mdf', move 'Logistics_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Logistics_log.ldf'
Nov 5, 2019 5:57:29 PM - Info dbclient (pid=6384) INF - Number of stripes: 1, Number of buffers per stripe 2.
Nov 5, 2019 5:57:30 PM - Info dbclient (pid=6384) INF - Created VDI object for SQL Server instance <HPPKLSQLCL01>. Connection timeout is <300> seconds.
Nov 5, 2019 6:02:35 PM - Info dbclient (pid=6384) ERR - Error in GetConfiguration: 0x80770003.
Nov 5, 2019 6:02:36 PM - Info dbclient (pid=6384) CONTINUATION: - The api was waiting and the timeout interval had elapsed.
Nov 5, 2019 6:02:38 PM - Info dbclient (pid=6384) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3201><[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open backup device 'VNBU0-6384-6120-1572956846'. Operating system error 0x80070002(The system cannot find the file specified.).>.
Nov 5, 2019 6:02:39 PM - Info dbclient (pid=6384) DBMS MSG - SQL Message <3013><[Microsoft][SQL Server Native Client 10.0][SQL Server]RESTORE DATABASE is terminating abnormally.>
Nov 5, 2019 6:02:40 PM - Info dbclient (pid=6384) ERR - Error found executing <restore database "Logistics" from VIRTUAL_DEVICE='VNBU0-6384-6120-1572956846' with stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery, move 'Logistics' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Logistics.mdf', move 'Logistics_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Logistics_log.ldf'>.
Nov 5, 2019 6:02:47 PM - Info dbclient (pid=6384) INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\logi.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 322(322) seconds.
Nov 5, 2019 6:02:50 PM - Info dbclient (pid=6384) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\logi.bch>:
Nov 5, 2019 6:02:50 PM - Info dbclient (pid=6384) <0> operations succeeded. <2> operations failed.

Global logging level was on minimum logging now I have set the same on 3

Hi,

 

Can you please check the path , mentioned in the script is right and valid ? As i am seeing some errors as below :

 

13:42:30.449 [1084.7452] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3201><[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open backup device 'VNBU0-1084-7452-1572941239'. Operating system error 0x80070002(The system cannot find the file specified.).>.

replace , norecovery, move 'GV' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARMS.mdf', move 'GV_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ARMS_1.ldf'>.

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@cprajput 

I was hoping to see more in level 3 or higher dbclient log. 
I have found similar errors online :
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 <3101><[Microsoft][ODBC SQL Server Driver][SQL Server]
With this additional info that we do not see in your logs: 
Exclusive access could not be obtained because the database is in use

So, I am missing a real reason from MS-SQL for the "SQL State <37000>, SQL Message <3101>" errors. 

I have see these errors in logs that you provided for which there is no accompanying Job Details:

14:25:05.617 [2320.7428] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <42000>, SQL Message <229><[Microsoft][SQL Server Native Client 10.0][SQL Server]The EXECUTE permission was denied on the object 'xp_loginconfig', database 'mssqlsystemresource', schema 'sys'.>.
14:25:05.617 [2320.7428] <16> CGlobalInformation::QuerySQLServerInfo: ERR - Error found executing <exec master.dbo.xp_loginconfig 'login mode'>

Can you please double-check DB credentials of the user performing the restore? 

Have you checked SQL Application Logs?
SQL VDI logs?
SQL Errorlog?