Sample Header Ad - 728x90

SQLPackage resets database recovery model

5 votes
1 answer
2091 views
I am using SQLPackage.exe with database publish profiles to deploy database changes to DEV and QC instances. I have databases in simple recovery mode. But when I deploy changes using SQLPackage, it reverts them to full recovery mode. This is what I am using, > "C:\Program Files (x86)\Microsoft SQL > Server\110\DAC\bin\SqlPackage.exe" /Action:Publish /SourceFile:"FILE > PATH TO .DACPAC" /Profile:"PUBLISH PROFILE.XML" If I use Visual Studio to deploy project changes using same publish project, same happens. What am I missing here? As far as I can tell, there is no such flag in Profile. Is this expected behavior of SQLPackage?
Asked by JackLock (466 rep)
Jan 28, 2020, 06:52 PM
Last activity: Feb 4, 2020, 07:10 PM