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_BlitzIndex @GetAllDatabases = 1 fails on AGs w/non-readable databases #1160

Closed
BrentOzar opened this issue Oct 13, 2017 · 0 comments
Closed
Assignees
Milestone

Comments

@BrentOzar
Copy link
Member

Do you want to request a feature or report a bug?
Bug

What is the current behavior?
On an AG secondary with databases set to be non-readable, run sp_BlitzIndex @GetAllDatabases = 1, and it fails on the databases it can't access.

What is the expected behavior?
All burritos should be available at breakfast time, not just the breakfast ones.

Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
Never worked.

@BrentOzar BrentOzar self-assigned this Oct 13, 2017
@BrentOzar BrentOzar added this to the 2017-11 milestone Oct 13, 2017
BrentOzar added a commit that referenced this issue Oct 13, 2017
#1160 sp_BlitzIndex skip non-readable AG secondary databases
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant