SQL Server – NT AUTHORITY\SYSTEM Cannot Access Database During Backup

sql serverwindows-server

When trying to automatically backup a MsSQL database on a Windows 2012 Server, the following exception is thrown, and hence the backup is not taken:

Description: Error encountered during backup. Error: [Microsoft.SqlServer.Management.Common.ExecutionFailureException:The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "TestDB" under the current security context. BACKUP DATABASE is terminating abnormally. An exception occurred while executing a Transact-SQL statement or batch.]

Best Answer

We had 2 instance and NB MSSQL Job was failing and we just added (NT AUTHORITY\SYSTEM) under sysadmin in security roles and restarted the Netbackup services. NB SQL Jobs Started working.