NBU備份出現權限問題導緻報錯

2019-5-2 19:02:05 - Info nbjm (pid=1260) starting backup job (jobid=34) for client SQLSERVER, policy sqlserver_DB_BK, schedule FULL_BK
           

2019-5-2 19:02:05 - Info nbjm (pid=1260) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=34, request id:{8D31E8AD-EC10-4A2D-B8FF-F6D4DA8690E3})
           

2019-5-2 19:02:05 - requesting resource Deduplication_Pool-stu
           

2019-5-2 19:02:05 - requesting resource nbumaster.NBU_CLIENT.MAXJOBS.SQLSERVER
           

2019-5-2 19:02:05 - requesting resource nbumaster.NBU_POLICY.MAXJOBS.sqlserver_DB_BK
           

2019-5-2 19:02:05 - granted resource  nbumaster.NBU_CLIENT.MAXJOBS.SQLSERVER
           

2019-5-2 19:02:05 - granted resource  nbumaster.NBU_POLICY.MAXJOBS.sqlserver_DB_BK
           

2019-5-2 19:02:05 - granted resource  Deduplication_Pool-stu
           

2019-5-2 19:02:05 - estimated 0 kbytes needed
           

2019-5-2 19:02:05 - Info nbjm (pid=1260) started backup (backupid=SQLSERVER_1556794925) job for client SQLSERVER, policy sqlserver_DB_BK, schedule FULL_BK on storage unit Deduplication_Pool-stu
           

經過核查此為SQL從2012版本之後若使用本地賬戶作為管理者權限需要将system賬戶添加sysadmin角色

2019-5-2 19:02:06 - Info bpbrm (pid=2492) SQLSERVER is the host to backup data from
           

2019-5-2 19:02:06 - Info bpbrm (pid=2492) reading file list for client
           

2019-5-2 19:02:06 - started process bpbrm (pid=2492)
           

2019-5-2 19:02:06 - connecting
           

2019-5-2 19:02:08 - Info bpbrm (pid=2492) starting bphdb on client
           

2019-5-2 19:02:08 - Info bphdb (pid=1724) Backup started
           

2019-5-2 19:02:08 - connected; connect time: 0:00:00
           

2019-5-2 19:02:10 - Info dbclient (pid=2052) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][SQL Server Native Client 11.0][SQL Server]伺服器主體 "NT AUTHORITY\SYSTEM" 無法在目前安全上下文下通路資料庫 "hongshuIT"。>.
           

2019-5-2 19:02:11 - Info dbclient (pid=2052) WARN - Error found executing <select groupname,groupid from "hongshuIT"..sysfilegroups order by groupname>.
           

2019-5-2 19:02:12 - Info dbclient (pid=2052) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][SQL Server Native Client 11.0][SQL Server]伺服器主體 "NT AUTHORITY\SYSTEM" 無法在目前安全上下文下通路資料庫 "model"。>.
           

2019-5-2 19:02:13 - Info dbclient (pid=2052) WARN - Error found executing <select groupname,groupid from "model"..sysfilegroups order by groupname>.
           

2019-5-2 19:02:13 - Info dbclient (pid=2052) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][SQL Server Native Client 11.0][SQL Server]伺服器主體 "NT AUTHORITY\SYSTEM" 無法在目前安全上下文下通路資料庫 "ReportServer"。>.
           

2019-5-2 19:02:14 - Info dbclient (pid=2052) WARN - Error found executing <select groupname,groupid from "ReportServer"..sysfilegroups order by groupname>.
           

2019-5-2 19:02:15 - Info dbclient (pid=2052) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][SQL Server Native Client 11.0][SQL Server]伺服器主體 "NT AUTHORITY\SYSTEM" 無法在目前安全上下文下通路資料庫 "ReportServerTempDB"。>.
           

2019-5-2 19:02:15 - Info dbclient (pid=2052) WARN - Error found executing <select groupname,groupid from "ReportServerTempDB"..sysfilegroups order by groupname>.
           

2019-5-2 19:02:17 - Info dbclient (pid=2052) INF - Error: Failed to query database metadata for <hongshuIT>
           

2019-5-2 19:02:19 - Info dbclient (pid=2052) INF - Error: Failed to query database metadata for <master>
           

2019-5-2 19:02:21 - Info dbclient (pid=2052) INF - Error: Failed to query database metadata for <model>
           

2019-5-2 19:02:24 - Info dbclient (pid=2052) INF - Error: Failed to query database metadata for <msdb>
           

2019-5-2 19:02:26 - Info dbclient (pid=2052) INF - Error: Failed to query database metadata for <ReportServer>
           

2019-5-2 19:02:29 - Info dbclient (pid=2052) INF - Error: Failed to query database metadata for <ReportServerTempDB>
           

2019-5-2 19:02:31 - Info dbclient (pid=2052) INF - Results of executing <C:\Program Files\SQLFULLBK.bch>: 
           

2019-5-2 19:02:31 - Info dbclient (pid=2052) <0> operations succeeded. <6> operations failed.
           

2019-5-2 19:02:31 - Info dbclient (pid=2052) INF - The following object(s) were not backed up successfully.
           

2019-5-2 19:02:32 - Info dbclient (pid=2052) INF - hongshuIT
           

2019-5-2 19:02:32 - Info dbclient (pid=2052) INF - master
           

2019-5-2 19:02:32 - Info dbclient (pid=2052) INF - model
           

2019-5-2 19:02:33 - Info dbclient (pid=2052) INF - msdb
           

2019-5-2 19:02:33 - Info dbclient (pid=2052) INF - ReportServer
           

2019-5-2 19:02:33 - Info dbclient (pid=2052) INF - ReportServerTempDB
           

2019-5-2 19:02:53 - Error bpbrm (pid=2492) from client SQLSERVER: ERR - command failed: none of the requested files were backed up (2)
           

2019-5-2 19:02:53 - Error bpbrm (pid=2492) from client SQLSERVER: ERR - bphdb exit status = 2: none of the requested files were backed up
           

2019-5-2 19:02:54 - Info bphdb (pid=1724) done. status: 2: none of the requested files were backed up
           

2019-5-2 19:02:54 - end writing
           

none of the requested files were backed up  (2)
           

經過排查為SQL從2012版本之後将本地賬戶作為管理者登入需要将system賦予sysadmin角色