NetWorker: NVP vProxy: MSVMAPPAGENT SQL Transaction Log Backups Failed "MSSQL Agent failed to create a transaction log backup".

Zusammenfassung: msvmagent_appbackup: O principal do servidor "NT AUTHORITY\SYSTEM" não consegue acessar o banco de dados "SQL_DB1" no contexto de segurança atual. 153416:msvmagent_appbackup: (Erro: 916) ...

Dieser Artikel gilt für Dieser Artikel gilt nicht für Dieser Artikel ist nicht an ein bestimmtes Produkt gebunden. In diesem Artikel werden nicht alle Produktversionen aufgeführt.

Symptome

A integração NetWorker VMware Protection está configurada com o equipamento vProxy.  O Microsoft VM App Agent (MSVMAPPAGENT) para proteção consistente com aplicativos SQL Server está sendo usado para executar um backup de uma máquina virtual (VM) com o Microsoft SQL Server.  O backup da VM apresenta falha indicando que o MSSQL Agent apresentou falha ao criar um backup de registro de transações.  Os detalhes da sessão do NetWorker Management Console (NMC) e o log da sessão mostram:
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".

A VM de destino C:\Program Files\DPSAPPS\MSVMAPPAGENT\logs\msvmagent_appbackup.log mostra:

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.

Ursache

O "NT AUTHORITY\SYSTEM" não tem direitos sysadmin concedidos aos bancos de dados microsoft SQL Server.

Lösung

O MSVMAPPAGENT é executado na conta SYSTEM para operações de proteção de dados.  Configure todas as instâncias do SQL Server na VM para conceder direitos de sysadmin da conta "NT AUTHORITY\SYSTEM":

image.png

Betroffene Produkte

NetWorker

Produkte

NetWorker
Artikeleigenschaften
Artikelnummer: 000055925
Artikeltyp: Solution
Zuletzt geändert: 12 Juni 2025
Version:  5
Antworten auf Ihre Fragen erhalten Sie von anderen Dell NutzerInnen
Support Services
Prüfen Sie, ob Ihr Gerät durch Support Services abgedeckt ist.