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.
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.