NetWorker: NVP vProxy: MSVMAPPAGENT SQL Transaction Log Backups Failing "MSSQL Agent failed to create a transaction log backup."
요약: msvmagent_appbackup: The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "SQL_DB1" under the current security context.
이 문서는 다음에 적용됩니다.
이 문서는 다음에 적용되지 않습니다.
이 문서는 특정 제품과 관련이 없습니다.
모든 제품 버전이 이 문서에 나와 있는 것은 아닙니다.
증상
The NetWorker VMware Protection (NVP) integration is configured with the vProxy Appliance.
Microsoft Virtual Machine (VM) App Agent (MSVMAPPAGENT) for SQL Server application-consistent protection is configured to perform a backup of a VM with Microsoft SQL Server.
The backup of the VM fails, indicating the MSSQL Agent failed to create a transaction log backup. The NetWorker Management Console (NMC) session details and session log shows:
YYYY/MM/DD HH:MM:SS INFO: [89] MSSQL: Executed MSSQL Agent operation 'backup_transaction_log' on guest VM.
YYYY/MM/DD HH:MM:SS INFO: [89] MSSQL: Executed MSSQL Agent operation 'monitor' on guest VM.
YYYY/MM/DD HH:MM:SS INFO: [89] MSSQL Agent: Performing transaction log backup for SQL instance 'VM_NAME'
YYYY/MM/DD HH:MM:SS ERROR: [89] MSSQL: MSSQL Agent:
YYYY/MM/DD HH:MM:SS ERROR: [89] MSSQL: backup_transaction_log: Failure monitoring progress: MSSQL Agent:
YYYY/MM/DD HH:MM:SS ERROR: [89] MSSQL: MSSQL Agent failed to create a transaction log backup.
YYYY/MM/DD HH:MM:SS ERROR: [89] MSSQL: Backup of the application "MSSQL Agent" on the virtual machine "VM_NAME" has failed.
YYYY/MM/DD HH:MM:SS INFO: [89] MSSQL: Disconnected from MSSQL Agent in "VM_NAME".
The target VM's C:\Program Files\DPSAPPS\MSVMAPPAGENT\logs\msvmagent_appbackup.log shows:
52701:msvmagent_appbackup: Command line: C:\Program Files\DPSAPPS\MSVMAPPAGENT\bin\msvmagent_appbackup.exe -i -
37693 MM/DD/YYYY HH:MM:SS msvmagent_appbackup NSR info SQL Connection to VM_NAME is created. SQL Server Version is 13.00.5026
...
153887:msvmagent_appbackup: Microsoft SQL server documentation provides details about the following SQL Server Provider error:
38008:msvmagent_appbackup: The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "SQL_DB1" under the current security context.
153416:msvmagent_appbackup: (Error: 916)
37938:msvmagent_appbackup: Failed to obtain filegroups for SQL_DB1.
Backing up SQL_DB1...
172257:msvmagent_appbackup: Backup of SQL_DB1 failed.원인
The "NT AUTHORITY\SYSTEM" is not granted sysadmin rights to the Microsoft SQL Server databases.
해결
The MSVMAPPAGENT runs under the SYSTEM account for data protection operations. Configure all SQL Server instances in the VM to grant "NT AUTHORITY\SYSTEM" account sysadmin rights:

해당 제품
NetWorker제품
NetWorker Family문서 속성
문서 번호: 000055925
문서 유형: Solution
마지막 수정 시간: 12 6월 2025
버전: 5
다른 Dell 사용자에게 질문에 대한 답변 찾기
지원 서비스
디바이스에 지원 서비스가 적용되는지 확인하십시오.