July 4, 2019 at 10:29 am
I have a SQL instance azure VM which is hosting SQL server. This instance contains multiple databases (few are full recovery and few are simple recovery). I have configured backup policy which takes full as well as log in recovery servicer vault. Problem is – when job gets triggered it takes full backup of all databases but there is a warning for log backup for those databases who are in simple recovery mode. How can I remove those databases who are in simple recovery mode from job policy so that job does not give any warning for not taking log backup of those databases which are in simple recovery mode. Thanks in advance.
July 5, 2019 at 11:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 5, 2019 at 3:56 pm
I think we have some language issues. You have a VM in Azure, which runs SQL Server, is that right? Inside here, you have a backup policy for SQL Server? I assume you have the workload backup extension that moves to a Service Recovery Vault, as shown here: https://azure.microsoft.com/en-us/blog/azure-backup-for-sql-server-in-azure-virtual-machines-now-generally-available/
Based on this: https://docs.microsoft.com/en-us/azure/backup/backup-sql-server-database-azure-vms
I would say you need separate policies for databases that are in simple mode. There doesn't appear to be any check for the configuration available, just a flat policy that performs a type of backup on any databases this applies to.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply