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.

/p:ScriptDatabaseOptions=False

Not that this option will skip ALL database options

Advertisements