搜索 <book_title>...

NetBackup™ for Microsoft SQL Server 管理指南

Last Published: 2025-10-28

Product(s): NetBackup (11.0.0.1)

当凭据规则中关联的凭据无效时，使用智能组的 SQL Server 策略备份可能会失败并显示状态码 200

在以下情况下，SQL Server 策略备份会失败，并显示状态码 200：

使用凭据规则发现并注册与策略中的智能组关联的实例。
使用策略中的智能组查询 NetBackup 环境中的数据库。

作业详细信息中会显示一条警告消息：No databases were found for instance {0}。此消息表明存在以下问题：NetBackup 尝试访问 SQL Server 实例或数据库，但 NetBackup 资产数据库显示为空。

作业详细信息中显示的错误：

Jan 15, 2025 11:45:00 AM - Info nbjm (pid=3606803) starting backup job (jobid=5) for 
client <mssql_client>, policy <mssql_auto_protect_policy>, schedule Full
Jan 15, 2025 11:45:00 AM - Info nbjm (pid=3606803) requesting MEDIA_SERVER_ONLY resources 
from RB for backup job (jobid=5, request id:{71277C90-D368-11EF-A88B-C711544AD613})
Jan 15, 2025 11:45:00 AM - requesting resource <media_bdstu>
Jan 15, 2025 11:45:00 AM - requesting resource <media_server>.NBU_CLIENT.MAXJOBS.
<media_server>
Jan 15, 2025 11:45:00 AM - granted resource <media_server>.NBU_CLIENT.MAXJOBS.
<media_server>
Jan 15, 2025 11:45:00 AM - estimated 0 kbytes needed
Jan 15, 2025 11:45:00 AM - begin Parent Job
Jan 15, 2025 11:45:00 AM - begin Application Resolver: Step By Condition
Operation Status: 0
Jan 15, 2025 11:45:00 AM - end Application Resolver: Step By Condition; elapsed time 
0:00:00
Jan 15, 2025 11:45:00 AM - begin Application Resolver: Resolver Discovery
Jan 15, 2025 11:45:01 AM - Warning nbpem (pid=3606866) No databases were found 
for instance {0}.
Jan 15, 2025 11:45:01 AM - Error nbpem (pid=3606866) backup of client <mssql_client> 
exited with status 200 (The scheduler found that no backups are due. Or, the target 
hosts do not need to be upgraded.)
Operation Status: 0
Jan 15, 2025 11:45:01 AM - end Application Resolver: Resolver Discovery; elapsed time 
0:00:01
Jan 15, 2025 11:45:01 AM - begin Application Resolver: Policy Execution Manager 
Preprocessed
Jan 15, 2025 11:45:01 AM - Warning nbpem (pid=3606866) No databases were found for 
instance {0}.
Operation Status: 200
Jan 15, 2025 11:45:01 AM - end Application Resolver: Policy Execution Manager 
Preprocessed; elapsed time 0:00:00
Jan 15, 2025 11:45:01 AM - begin Application Resolver: Stop On Error
Operation Status: 0
Jan 15, 2025 11:45:01 AM - end Application Resolver: Stop On Error; elapsed time 0:00:00
Operation Status: 200
Jan 15, 2025 11:45:01 AM - end Parent Job; elapsed time 0:00:01
The scheduler found that no backups are due. Or, the target hosts do not need to be 
upgraded.(200)

环境

支持的任何 Windows 版本
支持的任何 SQL Server 版本
NetBackup 11.0 或更高版本

原因

凭据规则中配置的凭据存在问题。规则可能包含无效的用户名或密码。或者，用户没有访问实例或数据库所需的权限。之所以会出现这种情况，是因为在创建凭据规则时，NetBackup 没有对凭据进行验证。假设这样一种情况：NetBackup 管理员收到 SQL Server 管理员创建凭据规则的请求。稍后，当 SQL Server 管理员激活凭据规则时，该管理员发现为该规则选择的凭据的用户名或密码已过期。

解决方案

验证为策略中包含的 SQL Server 实例或数据库配置的凭据。

验证凭据

在“实例”选项卡上，选中实例对应的复选框。
选择“管理凭据”。
选择“从现有凭据中选择”选项。
选择与凭据规则关联的凭据。
选择“下一步”。
查看验证显示消息。然后根据需要修改凭据。