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

PseudoSimple check failing on offline databases #612

Open
shaneis opened this Issue Mar 28, 2019 · 0 comments

Comments

Projects
None yet
1 participant
@shaneis
Copy link
Collaborator

commented Mar 28, 2019

Bug Report

Pseudosimple check reports offline databases as failing

General Troubleshooting steps

  • Verified running the latest release of dbachecks?

Does (Find-Module dbachecks).Version match (Get-Module dbachecks).Version.ToString()
Yessum, 1.1.171

image

  • Verified errors are not related to permissions?
  • Can duplicate in new/clean PowerShell session (clean = powershell -NoProfile)?

Version Information

  • Operating System (Name|Version):
    Microsoft Windows Server 2016 Datacenter
  • PowerShell Version:
Name                           Value
----                           -----
PSVersion                      5.1.14393.2155
PSEdition                      Desktop
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.14393.2155
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
  • SQL Server (Edition|Version):
    Microsoft SQL Server 2016 (RTM-CU9)

Steps to Reproduce

Turn a database offline and run Invoke-DbcCheck -check PseudoSimple

Description of Bug

Pseudosimple check does not check if the database is offline or not.
We can add it to the .Where{} scriptblock that removes tempdb, etc.

@shaneis shaneis referenced a pull request that will close this issue Apr 1, 2019

Open

Removed offline databases from PseudoSimple checks. #613

1 of 1 task complete
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.