03-15-2018 02:10 AM
Hi Guys,
I was wondering if any of you can maybe assist me with setting up this first time backup for this server.
I am unable to browse the SQL DB's for this server when trying to setup a legacy backup (batch file)
When registering the instance on the Netbackup server it works but when kicking of the backup we get a backupf failure with status 2. "1: (2) none of the requested files were backed up "
Netbackup Environment 8.1
SQl Client:
Server 2008 R2 Enterprise
SQL Server 2012
Error message: Application connection failed for *servername* when browsing on the client using Netbackup MS SQL client.
When the backup is kicked off using an Intelligent policy We picked up an error “ODBC connection setup failed” in the backup job details which fails and also in the logs on the client.
Troubleshooting thus far.
Thanks
03-15-2018 02:21 AM - edited 03-15-2018 05:41 AM
Could you please share level 3 dbclient log file (upload as .txt)?
It will be fine if you replace all host and database names with generic names, e.g. master, media1, client1, etc.
03-15-2018 02:52 AM
Nice to see a fellow South African
Which services did you change to use as srvstorbck and is srvstorbck a local admin on the box?
03-16-2018 06:33 AM
can we assume connectivity is fine with master / media & client server ??
are you able to perform file level backups?
04-06-2018 01:18 AM
Hi Marianne,
Appologies for the delay in feedback, been running around like a headless chicken.
Please find the attached dbclient log as requested.
Thanks
04-06-2018 01:21 AM
Hi There,
Netbackup client service
Netbackup Legacy client service
Netbackup Legacy Network service.
Yes srvstorbck is a local admin.
Thanks
04-06-2018 01:22 AM
Hi,
Yes can connect, ports open PING etc
File level backups work yes.
04-06-2018 04:01 AM
I will download the log file on my laptop when time permits.
I assist mostly in my own time using my mobile phone.
I can ONLY open files with .txt extensions on my phone.
04-09-2018 05:39 AM - edited 04-09-2018 05:40 AM
I had a look at the log file.
This is the 1st error that 'jumps out':
09:28:04.725 [14812.21964] <16> CGlobalInformation::QuerySQLServerInfo: ERR - Error in RegConnectRegistry, opening <HKEY_LOCAL_MACHINE> key on <\\>: 1707. The text follows:
Google found this TN: https://www.veritas.com/support/en_US/article.100016336
Extract:
The above errors indicate that NetBackup has issues connecting to the registry information.
Check the Windows Remote Registry Service and make sure it is installed and running on the SQL Server.
04-09-2018 10:20 PM - edited 04-09-2018 10:23 PM
Thanks Marianne,
I had a look at the Service and I see its installed and started. I gave it a restart for good measure.
I still get the error unfortunately. I have asked the SQL admin to check the ODBC driver on this box as I also see this error
repeated in the logs. I will feedback to the forum if I find anything. thanks for the assistance thus far.
Regards
04-10-2018 12:06 AM
It seems like a permission related issue.
Going further down the log, we see this :
09:28:05.989 [14812.21964] <4> SQLEnumerator: INF - Could not enumerate SQL hosts with SQLBrowseConnectW
09:28:05.989 [14812.21964] <4> CGlobalInformation::SQLEnumerator: INF - Hosts and instances retrieved from host list string
09:28:05.989 [14812.21964] <4> CGlobalInformation::SQLEnumerator: INF - host: dhpcrm01new
09:28:05.989 [14812.21964] <4> CGlobalInformation::SQLEnumerator: INF - instance: <default>
09:28:05.989 [14812.21964] <4> CGlobalInformation::SQLEnumerator: INF - instance: POWERPIVOT
09:28:05.989 [14812.21964] <8> AugmentInstanceList: WARN - Cannot query <HKLM\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\\InstalledInstances> on <\\dhpcrm01new>. Status <2>
09:28:05.989 [14812.21964] <1> AugmentInstanceList: CONTINUATION: - The system cannot find the file specified.
09:28:05.989 [14812.21964] <4> CSQLDBMSOptions::OnInitDialog: INF - It is unknown whether NetBackup for Microsoft SQL Server is installed on host machine
09:28:28.251 [14812.21964] <4> CGlobalInformation::CreateDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
09:28:28.251 [14812.21964] <4> CGlobalInformation::CreateDSN: INF - Error Creating ODBC data source name
09:28:28.251 [14812.21964] <1> CGlobalInformation::CreateDSN: CONTINUATION: - The setup routines for the SQL Server Native Client 10.0 ODBC driver could not be loaded due to system error code 193: .
09:28:28.251 [14812.21964] <16> CSQLDBMSOptions::OnApply: ERR - Error 1 has been returned from QuerySQLServerInfo
09:28:30.263 [14812.21964] <8> AugmentInstanceList: WARN - Cannot query <HKLM\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\\InstalledInstances> on <\\dhpcrm01new>. Status <2>
09:28:30.263 [14812.21964] <1> AugmentInstanceList: CONTINUATION: - The system cannot find the file specified.
09:28:30.263 [14812.21964] <4> CSQLDBMSOptions::OnInitDialog: INF - It is unknown whether NetBackup for Microsoft SQL Server is installed on host machine
09:28:31.511 [14812.21964] <4> CGlobalInformation::CreateDSN: INF - Using ODBC Driver <SQL Server Native Client 10.0>
Is UAC enabled?
Are you starting the NBU for SQL GUI with 'run as Admin'?
Something else that may seem silly but worth checking - can you verify that all parameters in NBU MS-SQL connection properties are correct?
I have just opened the GUI on my laptop (no SQL installed - just wanted to check the fields).
It opens with totally WEIRD entries - hostname has nothing to do with my laptop name and I have no idea where the instance name comes from! (I have nothing to do with Veeam!)
Please see the attached screenshot.
The errors/messages seen in your log makes me wonder if the correct host is selected?
Other than that - permission or UAC issue?
04-16-2018 04:25 AM
Hi Marianne,
UAC is not enabled. I run Netbackup MS SQL client as admin yes and also the hostname selected is the correct name.
Im also an administrator on this box. I also tried the FQDN, ive tried playing around with it but the error pops up immediatey.
This is a tough one I just cant seem to find the issue.