SQL backup fail with statuscode 2
Hi
We have a 2008 SQL server that we can't backup from the master.
It fails wit statuscode 2
Backup from the client works well.
Env:
Master: Windows 2008
Client : windows 2008 with SQL server 2008
Netbackup version: 7.6.0.1
I have attached the dbclient log (dbclient_log.doc) and the output from from the job (servertest.doc)
We have other W2008 server with SQL server 2008 where netbackup is working.
Any help is appreciated.
//Lasse
This is your problem:
<16> CODBCaccess::LogODBCerr: DBMS MSG - SQL Message <87><[Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.>
First check is to work with the SQL dba to ensure SQL instance is up and running.
Check that all info in SQL backup script is correct.
If Instance and/or database names are specified, check that all are correct.
Carefully check for typo errors.
Check if Client name is correct in the script.Lastly, check that NBU Client Service on the SQL server is started as a domain account with sufficient SQL priveleges.
Best is to start NBU services with same logon account as SQL services.
use domain accout having admin privilages to start netbackup client service and netbackup legacy network services.
Also create a role in MS SQL with sysadmin privilages and connect to instance to backup SQL objects using this user and then try to run the backup.