In scenarios where MSSQL Backups fail, please go through the troubleshooting and validations captured in this KB
Problem:
MSSQL Backups fail
Solution:
Validate the pre-requisites specified below and then trigger the backup again.
- The instance name of the SQL server should be “MSSQLSERVER“
- The new login should be created for “amandabackup” user on the SQL server
- make sure that ,during adding new login for “amandabackup” , let it be “windows authentication“ and not “SQL server authentication“
- The amandabackup user must be given with “sysadmin“ role.
- If backups fails sometimes with error ”failed to set shm ring“ , then it is due to microsoft Volume shadow copy writer on client which might have stopped. Start the VSS writer and try backup again
