Home Dashboard Directory Help
Search

SSDT and Database Projects - Need "Ignore Recovery Mode" Flag by John Saunders, ECx


Status: 

Closed
 as Won't Fix Help for as Won't Fix


2
0
Sign in
to vote
Type: Suggestion
ID: 790501
Opened: 6/19/2013 12:44:28 PM
Access Restriction: Public
0
Workaround(s)
view

Description

We want the QA instances of our database to be in SIMPLE recovery mode. We want most of the Production instances to be in FULL mode, though we want some of them to be in SIMPLE mode.

I don't see any way to do either of these things.
Details
Sign in to post a comment.
Posted by Microsoft on 8/13/2013 at 9:04 PM
Hi John,

One thing you could try is the publish setting to "Deploy database properties". When you uncheck this option, it will not deploy Recovery Mode or any other database-level property. You could then have different publish profiles, one with the setting on and one with it off.

Although this would impact more properties than just Recovery Mode, this may give you what you need.

Thanks for your feedback!

~Martin
Sign in to post a workaround.