NetWorker NVP-vProxy： 基于 vProxy 的 SQL 事务日志备份失败：在虚拟机“SQL_SERVER_NAME”上备份应用程序“MSSQL 代理”失败。
Summary: 使用 NetWorker VMware Protection （NVP） vProxy 一体机在 VMware 虚拟机上执行 Microsoft SQL 备份。将 SQL Server 配置为“简单恢复”模式时，事务日志备份失败。
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
执行基于 vProxy 的 SQL Server 事务日志备份失败。 来自 vProxy 的备份会话日志显示以下消息：
SQL Server 的 C：\Program Files\DPSAPPS\MSVMAPPAGENT\logs\msvmagent_appbackup.log 显示以下内容：
YYYY-MM-DDTHH:mm:SSZ ERROR: [89] MSSQL: MSSQL:backup_transaction_log: NetWorker VM agent for Microsoft Applications:
YYYY-MM-DDTHH:mm:SSZ INFO: [89] MSSQL: MSSQL:backup_transaction_log: ====Output from MSSQL Agent monitor:
YYYY-MM-DDTHH:mm:SSZ INFO: [89] MSSQL: MSSQL:backup_transaction_log: Activity log:
YYYY-MM-DDTHH:mm:SSZ INFO: [89] MSSQL: MSSQL:backup_transaction_log: Request #264 from vproxy-name at YYYY-MM-DD HH:mm:SS -TZ
YYYY-MM-DDTHH:mm:SSZ INFO: [89] MSSQL: MSSQL:backup_transaction_log: Application agent operation: MSSQL monitor ##
YYYY-MM-DDTHH:mm:SSZ INFO: [89] MSSQL: MSSQL:backup_transaction_log: NetWorker VM agent for Microsoft Applications command error: exit status 1
YYYY-MM-DDTHH:mm:SSZ INFO: [89] MSSQL: MSSQL:backup_transaction_log: NetWorker VM agent for Microsoft Applications:
YYYY-MM-DDTHH:mm:SSZ INFO: [89] MSSQL: MSSQL:backup_transaction_log: ====End of output from MSSQL Agent monitor.
YYYY-MM-DDTHH:mm:SSZ ERROR: [89] MSSQL: MSSQL:backup_transaction_log: NetWorker VM agent for Microsoft Applications:
YYYY-MM-DDTHH:mm:SSZ ERROR: [89] MSSQL: Backup of the application "MSSQL Agent" on the virtual machine "SQL_SERVER_NAME" has failed.
SQL Server 的 C：\Program Files\DPSAPPS\MSVMAPPAGENT\logs\msvmagent_appbackup.log 显示以下内容：
37693 YYYY-MM-DD HH:mm:SS msvmagent_appbackup NSR info SQL Connection to SQL_SERVER_NAME is created. SQL Server Version is ##.##.####
master is a system database. Backup of database master will be skipped.
model is a system database. Backup of database model will be skipped.
msdb is a system database. Backup of database msdb will be skipped.
Recovery model of database User_Database_Name is simple. Backup of database User_Database_Name will be skipped.
tempdb is a system database. Backup of database tempdb will be skipped.
29211:msvmagent_appbackup: At least 1 valid backup target is required
Cause
Microsoft SQL 不允许对设置为简单恢复模式的数据库执行事务日志备份。 备份被标记为失败，因为此 SQL Server 上没有事务日志备份的有效目标。
Resolution
如果更改了用户创建的数据库恢复模式，则可以执行 SQL 事务日志备份。 如果需要事务日志备份，请咨询数据库管理员如何更改数据库的恢复模式。如果需要将数据库设置为保持在简单恢复模式下，则只能运行完整 SQL 备份。
这是按设计运行的。
这是按设计运行的。
Additional Information
Affected Products
NetWorkerProducts
NetWorkerArticle Properties
Article Number: 000174302
Article Type: Solution
Last Modified: 04 Sept 2025
Version: 4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.