搜索 <book_title>...

NetBackup™ for Microsoft SQL Server 管理指南

Last Published: 2025-04-24

Product(s): NetBackup & Alta Data Protection (11.0)

当凭据规则中关联的凭据无效时，使用智能组的 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 实例或数据库配置的凭据。

验证凭据

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