Forum Discussion

Bharath_Achar's avatar
11 years ago

SQL DB backup is failing with status (2) none of the requested files were backed up

Could some help me resolving this issue -

 

SQl database backup failing with stutus below -

(2) none of the requested files were backed up.

 

I have attached the detailed status of the job.

 

  • 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 "ACSI-Dev" under the current security context.>.

     

    https://www-secure.symantec.com/connect/forums/sql-backup-problem-1

    Change NBU Client Service to user account with sufficient SQL rights.

    Best to start NBU service with same logon account as SQL services.

2 Replies

  • 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 "ACSI-Dev" under the current security context.>.

     

    https://www-secure.symantec.com/connect/forums/sql-backup-problem-1

    Change NBU Client Service to user account with sufficient SQL rights.

    Best to start NBU service with same logon account as SQL services.