Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sp_DatabaseRestore: Add param to enable service broker on restore #3532

Closed
lowlydba opened this issue Jun 6, 2024 · 2 comments · Fixed by #3543
Closed

sp_DatabaseRestore: Add param to enable service broker on restore #3532

lowlydba opened this issue Jun 6, 2024 · 2 comments · Fixed by #3543

Comments

@lowlydba
Copy link
Contributor

lowlydba commented Jun 6, 2024

Is your feature request related to a problem? Please describe.
I'd like to be able to, via parameter, restore using sp_DatabaseRestore and include the functionality of ENABLE_BROKER (docs) so that existing service brokers in the restored database are enabled.

ENABLE_BROKER
Specifies that Service Broker message delivery is enabled at the end of the restore so that messages can be sent immediately. By default Service Broker message delivery is disabled during a restore. The database retains the existing Service Broker identifier.

Describe the solution you'd like
Something like @EnableBroker to achieve the above.

Describe alternatives you've considered
I can do it as a separate statement myself, but that could be said about most of this proc's functionality 🙃

Are you ready to build the code for the feature?
Sure, very easy implementation for this.

@BrentOzar
Copy link
Member

Makes sense! Go for it. Thanks!

@BrentOzar
Copy link
Member

Thanks for the PR! Looks good, makes sense, merging into the dev branch. I'm doing a July release a little early to get a couple of fixes into the Consultant Toolkit, and this will be in there.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment