MS SQL Server DB backups failing with "Error: Failed to query database metadata for..."

Hi,

The error got resolved... :-)

The issue was that earlier we were using 'sa' user for taking backups which were running successfully.

Then as a part of hardening the SQL team created a new user 'sysbackup' and asked to replace the 'sa' user with it. Since then all the backups started failing.

I told the SQL team that there's some permission short for 'sysbackup' user but they said they're able to fire backups successfully from their end and hence it's not a permission issue.

I opened a ticket with Veritas support and after more than an hour of struggling the support engineer changed the user in NetBackup client's connection properties to the domain user which we use for logging and recreated the backup scrpt and the backup executed successfully.

After comparing permissions of both the domain and 'sysbackup' user and it was discovered that the domain user has the role 'sysadmin' assigned to it.

Now the SQL team is saying they cannot assign 'sysadmin' role to 'sysbackup' user and also cannot allow backups to run with the domain user which is a security violation and also the domain users' password changes every 30 days in which case we'll have to update the connection properties ever month.

Is there any way where we can schedule backups with the 'sysbackup' user without assigning 'sysadmin' role to it?

Herewith documented requirements:

https://www.veritas.com/support/en_US/article.100017184.html

I believe there is no workaround.