Forum Discussion

rpandey's avatar
rpandey
Level 3
10 years ago

SQL Database backup issue on SQL 2012 server

Hi,

I have configured SQL database and while i try to run backup it is failing with return code 2 (see below attached log) . I have generated batch file using different user name than 'sa'.  My environment is as follows - 

Windows 2012 server

SQL 2012 Server

Netbackup - 7.6.0.2

 

Please help me to resolve this issue. 

Detail status - 

 

5/6/2015 2:42:08 PM - Info nbjm(pid=6392) starting backup job (jobid=963357) for client syd1404, policy FCP-SYD-ADFS-SYD1404-SQL, schedule FULL  
5/6/2015 2:42:08 PM - Info nbjm(pid=6392) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=963357, request id:{6DFD9291-E6A9-4EE4-8E9C-9E2F6F8DDE44})  
5/6/2015 2:42:08 PM - requesting resource CSD-SYD-STU-PD2
5/6/2015 2:42:08 PM - requesting resource csd-nbumaster.NBU_CLIENT.MAXJOBS.syd1404
5/6/2015 2:42:08 PM - requesting resource csd-nbumaster.NBU_POLICY.MAXJOBS.FCP-SYD-ADFS-SYD1404-SQL
5/6/2015 2:42:08 PM - granted resource csd-nbumaster.NBU_CLIENT.MAXJOBS.syd1404
5/6/2015 2:42:08 PM - granted resource csd-nbumaster.NBU_POLICY.MAXJOBS.FCP-SYD-ADFS-SYD1404-SQL
5/6/2015 2:42:08 PM - granted resource CSD-SYD-STU-PD2
5/6/2015 2:42:08 PM - estimated 0 Kbytes needed
5/6/2015 2:42:08 PM - Info nbjm(pid=6392) started backup (backupid=syd1404_1430887328) job for client syd1404, policy FCP-SYD-ADFS-SYD1404-SQL, schedule FULL on storage unit CSD-SYD-STU-PD2
5/6/2015 2:42:10 PM - started process bpbrm (169236)
5/6/2015 2:42:12 PM - connecting
5/6/2015 2:42:14 PM - connected; connect time: 0:00:02
5/6/2015 2:42:15 PM - Info dbclient(pid=5604) DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.>.
5/6/2015 2:42:15 PM - Info dbclient(pid=5604) DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'sa'.>.
5/6/2015 2:42:19 PM - Info dbclient(pid=5604) DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'sa'.>.
5/6/2015 2:42:19 PM - Info dbclient(pid=5604) USER - Unable to login into ODBC DSN <NBMSSQL_5604_4808_2> as user <sa> 
5/6/2015 2:42:23 PM - Info dbclient(pid=5604) DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'sa'.>.
5/6/2015 2:42:23 PM - Info dbclient(pid=5604) USER - Unable to login into ODBC DSN <NBMSSQL_5604_4808_2> as user <sa> 
5/6/2015 2:42:28 PM - Info dbclient(pid=5604) DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'sa'.>.
5/6/2015 2:42:28 PM - Info dbclient(pid=5604) USER - Unable to login into ODBC DSN <NBMSSQL_5604_4808_2> as user <sa> 
5/6/2015 2:42:28 PM - Info dbclient(pid=5604) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\BKUP_FULL.bch>:      
5/6/2015 2:42:28 PM - Info dbclient(pid=5604) <0> operations succeeded. <0> operations failed.       
5/6/2015 2:42:31 PM - Info bpbrm(pid=169236) syd1404 is the host to backup data from     
5/6/2015 2:42:31 PM - Info bpbrm(pid=169236) reading file list for client        
5/6/2015 2:42:33 PM - Info bpbrm(pid=169236) starting bphdb on client         
5/6/2015 2:42:33 PM - Info bphdb(pid=5084) Backup started           
5/6/2015 2:42:50 PM - end writing

7.6
Backing Up
Backup and Recovery
Best Practice
Compatibility
Configuring
Error messages
Features
Installing
NetBackup
  • Marianne's avatar
    Marianne
    10 years ago

    You need to find out how authentication is configured on this SQL server and confirm that NBU services is started as correct user account.

    Have a look at this topic in NetBackup for Microsoft SQL Server Administrator's Guide 
     

     Configuring the NetBackup services for SQL Server backups and restores 

    NetBackup uses the NetBackup Client Service and the NetBackup Legacy Network
    Service to access the SQL Server when it performs backups and restores. To have
    the necessary permissions, the logon account NetBackup uses for these services
    must have the fixed server role “sysadmin.” Both services must use the same logon
    account.
    Choose a logon account for the NetBackup services as follows:

    ■ For SQL Server 2012, you must first apply the sysadmin role manually to the
    NT AUTHORITY\SYSTEM or the BUILTIN\Administrators group. Then you can
    use Local System for the logon accounts for the NetBackup services.
    ■ You can use another account as the logon account if it has the sysadmin role.

1 Reply

Sort By
  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    You need to find out how authentication is configured on this SQL server and confirm that NBU services is started as correct user account.

    Have a look at this topic in NetBackup for Microsoft SQL Server Administrator's Guide 
     

     Configuring the NetBackup services for SQL Server backups and restores 

    NetBackup uses the NetBackup Client Service and the NetBackup Legacy Network
    Service to access the SQL Server when it performs backups and restores. To have
    the necessary permissions, the logon account NetBackup uses for these services
    must have the fixed server role “sysadmin.” Both services must use the same logon
    account.
    Choose a logon account for the NetBackup services as follows:

    ■ For SQL Server 2012, you must first apply the sysadmin role manually to the
    NT AUTHORITY\SYSTEM or the BUILTIN\Administrators group. Then you can
    use Local System for the logon accounts for the NetBackup services.
    ■ You can use another account as the logon account if it has the sysadmin role.