Failed to backup ‘PDM_Vault’ database with ‘Full’ backup type: Cannot drop the database ‘SQLBackupAndFTP_PDM_VAULT_SNAPSHOT’, because it does not exist or you do not have permission."
Up until a month ago, I was able to backup my PDM_Vault database residing on a MS SQL Server Express 2014 database with just a warning stating:
For an export to be transactionally consistent, you must ensure either that no write activity is occurring during the export, or that you are exporting from a snapshot of your database. Turn on “Create database snapshot for backup” option at Backup options section for export to be transactionally consistent.
But it was backing up. I would get daily reports on how it was doing and I was happy with the results.
Then it started throwing this error and I haven’t been able to fix it. Is there a permission I should grant the user it is using in order to be able to backup the database again?