In lower level environments, we normally set the database in “Simple” recovery model to save resources. However, when use SqlPackage to generate deploy scripts from a Dacpack file, it always puts an alter statement to change the recovery model to FULL.

To resolve this, we have to exclude the database options while generating the deploy scripts.


Not that this option will skip ALL database options