SQL Server Backup and Restore failed in Netbackup

[zuhaib_siddiqui]

Hi all

I have created a batch/script file for SQL server 2012 backup, Script creates successfully on my SQL server. After that I created a policy for SQL server backup and add that script file in my newly created SQL backup policy in Netbackup 7.6

Scenerio 1:- 

When I run manual backup from Netbackup Master server, an error occurs and backup gone failed with the following logs.

9/29/2015 1:46:19 PM - Info nbjm(pid=3740) starting backup job (jobid=158) for client sqlserver, policy sql_pol_new, schedule Full 

9/29/2015 1:46:19 PM - Info nbjm(pid=3740) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=158, request id:{69D3D288-3ED9-4463-9D40-59F105F4F272}) 

9/29/2015 1:46:19 PM - requesting resource SQL

9/29/2015 1:46:19 PM - requesting resource nbumaster.NBU_CLIENT.MAXJOBS.sqlserver

9/29/2015 1:46:19 PM - requesting resource nbumaster.NBU_POLICY.MAXJOBS.sql_pol_new

9/29/2015 1:46:19 PM - granted resource nbumaster.NBU_CLIENT.MAXJOBS.sqlserver

9/29/2015 1:46:19 PM - granted resource nbumaster.NBU_POLICY.MAXJOBS.sql_pol_new

9/29/2015 1:46:19 PM - granted resource SQL

9/29/2015 1:46:19 PM - estimated 0 Kbytes needed

9/29/2015 1:46:19 PM - Info nbjm(pid=3740) started backup (backupid=sqlserver_1443516379) job for client sqlserver, policy sql_pol_new, schedule Full on storage unit SQL

9/29/2015 1:46:19 PM - started process bpbrm (1248)

9/29/2015 1:46:21 PM - Info bpbrm(pid=1248) sqlserver is the host to backup data from    

9/29/2015 1:46:21 PM - Info bpbrm(pid=1248) reading file list for client       

9/29/2015 1:46:21 PM - connecting

9/29/2015 1:46:24 PM - Info bpbrm(pid=1248) starting bphdb on client        

9/29/2015 1:46:24 PM - connected; connect time: 0:00:03

9/29/2015 1:46:25 PM - Info bphdb(pid=3540) Backup started          

9/29/2015 1:46:25 PM - Info dbclient(pid=2412) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "model" under the current security context.>.

9/29/2015 1:46:25 PM - Info dbclient(pid=2412) WARN - Error found executing <select groupname,groupid from "model"..sysfilegroups order by groupname>.

9/29/2015 1:46:27 PM - Info dbclient(pid=2412) INF - BACKUP STARTED USING       

9/29/2015 1:46:27 PM - Info dbclient(pid=2412) Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)    

9/29/2015 1:46:27 PM - Info dbclient(pid=2412) Oct 19 2012 13:38:57        

9/29/2015 1:46:27 PM - Info dbclient(pid=2412) Copyright (c) Microsoft Corporation        

9/29/2015 1:46:27 PM - Info dbclient(pid=2412) Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

9/29/2015 1:46:27 PM - Info dbclient(pid=2412) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\scriptnew290915.bch, Op# = 1     

9/29/2015 1:46:27 PM - Info dbclient(pid=2412) INF - Using backup image sqlserver.MSSQL7.SQLSERVER.db.master.~.7.001of001.20150929134625..C      

9/29/2015 1:46:27 PM - Info dbclient(pid=2412) INF - backup database "master" to VIRTUAL_DEVICE='VNBU0-2412-2144-1443516387' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 4

9/29/2015 1:46:27 PM - Info dbclient(pid=2412) INF - Number of stripes: 1, Number of buffers per stripe 4.

9/29/2015 1:46:27 PM - Info dbclient(pid=2412) INF - Created VDI object for SQL Server instance <sqlserver>. Connection timeout is <1500> seconds.

Scenerio 2:-

When i run Backup from SQL server client through netbackup MS SQL Client, Backup runs and completed successfully.

Please help me in this regards as i am unable to create backup and restore of SQL server

Environment:- 

Master Server:-

OS:- Windows Server 2008 R2 Enterprise

Netbackup 7.6.0.1

Client (SQL Server):-

OS:-  Windows Server 2008 R2 Enterprise

Netbackup Client 7.6.0.1

Regards

Zuhaib Siddiqui

[Marianne]

Scenerio 1:- 

The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "model" under the current security context..

Change the NetBackup Client service logon account to the same account you use to login for Scenerio 2  or else use a Service Account with sufficient rights.

[zuhaib_siddiqui]

Dear  Marianne

I am login with local administrator credentials on both Master server and Client (SQL server)

I have Change the Netbackup client services logon account as local administrator on my client (SQL server) but the problem is still persist.

Regards

[Marianne · Accepted solution]

You need to change logon account to an account with SQL admin rights.

See :
Configuring the NetBackup services for SQL Server backups and restores 
in NetBackup for Microsoft SQL Server Administrator's Guide 

 

[zuhaib_siddiqui]

Dear Marianne

Thanks for your help and time.

regards

ZIS