系统集成NBU

NBU备份SQL出现报错,请高手指导一下?

SQL安装在windows 2008的操作系统上,SQL版本是2012,NBU版本是7.7.3备份SQL,脚本如下:OPERATION BACKUPDATABASE $ALLSQLHOST "WIN-97JNF418UPC"SQLINSTANCE "MSSQLSERVER"NBSERVER "10.106.9.100"MAXTRANSFERSIZE 6BLOCKSIZE 7NUMBUFS 2ENDOPER TRUE备份报错信息:2018-6-6 18:...显示全部

SQL安装在windows 2008的操作系统上,SQL版本是2012,NBU版本是7.7.3
备份SQL,脚本如下:
OPERATION BACKUP
DATABASE $ALL
SQLHOST "WIN-97JNF418UPC"
SQLINSTANCE "MSSQLSERVER"
NBSERVER "10.106.9.100"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

备份报错信息:
2018-6-6 18:06:51 - Info nbjm (pid=3508) starting backup job (jobid=47) for client 10.106.9.102, policy qq, schedule testq
2018-6-6 18:06:51 - Info nbjm (pid=3508) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=47, request id:{DB703EC8-7028-4321-90D3-9E1FAC54E768})
2018-6-6 18:06:51 - requesting resource beifen
2018-6-6 18:06:51 - requesting resource win-vj615qs0d5p.NBU_CLIENT.MAXJOBS.10.106.9.102
2018-6-6 18:06:51 - requesting resource win-vj615qs0d5p.NBU_POLICY.MAXJOBS.qq
2018-6-6 18:06:51 - granted resource win-vj615qs0d5p.NBU_CLIENT.MAXJOBS.10.106.9.102
2018-6-6 18:06:51 - granted resource win-vj615qs0d5p.NBU_POLICY.MAXJOBS.qq
2018-6-6 18:06:51 - granted resource beifen
2018-6-6 18:06:52 - estimated 0 kbytes needed
2018-6-6 18:06:52 - Info nbjm (pid=3508) started backup (backupid=10.106.9.102_1528279611) job for client 10.106.9.102, policy qq, schedule testq on storage unit beifen
2018-6-6 18:06:52 - started process bpbrm (pid=5228)
2018-6-6 18:06:54 - Info bpbrm (pid=5228) 10.106.9.102 is the host to backup data from
2018-6-6 18:06:54 - Info bpbrm (pid=5228) reading file list for client
2018-6-6 18:06:55 - connecting
2018-6-6 18:06:59 - Info bpbrm (pid=5228) starting bphdb on client
2018-6-6 18:06:59 - Info bphdb (pid=3008) Backup started
2018-6-6 18:06:59 - connected; connect time: 0:00:00
2018-6-6 18:07:01 - Info dbclient (pid=3636) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><Microsoft[SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "lin" under the current security context.>.
2018-6-6 18:07:02 - Info dbclient (pid=3636) WARN - Error found executing <select groupname,groupid from "lin"..sysfilegroups order by groupname>.
2018-6-6 18:07:03 - Info dbclient (pid=3636) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><Microsoft[SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "model" under the current security context.>.
2018-6-6 18:07:04 - Info dbclient (pid=3636) WARN - Error found executing <select groupname,groupid from "model"..sysfilegroups order by groupname>.
2018-6-6 18:07:05 - Info dbclient (pid=3636) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><Microsoft[SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "ReportServer" under the current security context.>.
2018-6-6 18:07:06 - Info dbclient (pid=3636) WARN - Error found executing <select groupname,groupid from "ReportServer"..sysfilegroups order by groupname>.
2018-6-6 18:07:06 - Info dbclient (pid=3636) DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><Microsoft[SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "ReportServerTempDB" under the current security context.>.
2018-6-6 18:07:07 - Info dbclient (pid=3636) WARN - Error found executing <select groupname,groupid from "ReportServerTempDB"..sysfilegroups order by groupname>.
2018-6-6 18:07:11 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <lin>
2018-6-6 18:07:14 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <master>
2018-6-6 18:07:17 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <model>
2018-6-6 18:07:20 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <msdb>
2018-6-6 18:07:23 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <ReportServer>
2018-6-6 18:07:26 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <ReportServerTempDB>
2018-6-6 18:07:29 - Info dbclient (pid=3636) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\qqqqqqqq.bch>:
2018-6-6 18:07:29 - Info dbclient (pid=3636) <0> operations succeeded. <6> operations failed.
2018-6-6 18:07:29 - Info dbclient (pid=3636) INF - The following object(s) were not backed up successfully.
2018-6-6 18:07:30 - Info dbclient (pid=3636) INF - lin
2018-6-6 18:07:31 - Info dbclient (pid=3636) INF - master
2018-6-6 18:07:32 - Info dbclient (pid=3636) INF - model
2018-6-6 18:07:33 - Info dbclient (pid=3636) INF - msdb
2018-6-6 18:07:34 - Info dbclient (pid=3636) INF - ReportServer
2018-6-6 18:07:34 - Info dbclient (pid=3636) INF - ReportServerTempDB
2018-6-6 18:07:54 - Error bpbrm (pid=5228) from client 10.106.9.102: ERR - command failed: none of the requested files were backed up (2)
2018-6-6 18:07:54 - Error bpbrm (pid=5228) from client 10.106.9.102: ERR - bphdb exit status = 2: none of the requested files were backed up
2018-6-6 18:07:57 - Info bphdb (pid=3008) done. status: 2: none of the requested files were backed up
2018-6-6 18:07:57 - end writing
none of the requested files were backed up (2)

收起
参与7

返回a520520168的回答

a520520168a520520168  系统工程师 , 索菲亚

018-6-6 18:07:11 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <lin>
2018-6-6 18:07:14 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <master>
2018-6-6 18:07:17 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <model>
2018-6-6 18:07:20 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <msdb>
2018-6-6 18:07:23 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <ReportServer>
2018-6-6 18:07:26 - Info dbclient (pid=3636) INF - Error: Failed to query database metadata for <ReportServerTempDB>

================
你的库本身不行吧。。。或者你安装的client没设置好。

轻工业 · 2018-06-07
浏览6905

回答者

a520520168
系统工程师索菲亚
擅长领域: 云计算存储服务器

a520520168 最近回答过的问题

回答状态

  • 发布时间:2018-06-07
  • 关注会员:2 人
  • 回答浏览:6905
  • X社区推广