V-213773 - control may be able to be automated

[asturtevant]

Part of the control asks to verify the database recovery model.

This can be performed with the following query:
select
name, recovery_model_desc
from
sys.databases

It can be automated using:
In SQL Server Management Studio, Object Explorer, right-click on the name of the database; select Properties. Select the Options page. Set the Recovery Model field, near the top of the page, to the correct value.

In Object Explorer, expand >> SQL Server Agent >> Jobs. Create, modify and delete jobs to implement the backup schedule.