Open
Description
Database level checks need some Pester V5 love
Each check needs rewritten and added to: \checks\Databasev5.Tests.ps1
We will also need to improve performance by reducing the trips to the instance/database and gathering all information in one hit before discovery, similar to initfields in #882
- AsymmetricKeySize
- AutoClose
- AutoCreateStatistics
- AutoShrink
- AutoUpdateStatistics
- AutoUpdateStatisticsAsynchronously
- CertificateExpiration
- CLRAssembliesSafe
- CompatibilityLevel
- ContainedDBAutoClose
- ContainedDBSQLAuth
- DatabaseCollation
- DatabaseExists
- DatabaseGrowthEvent
- DatabaseMailEnabled
- DatabaseMailProfile
- DatabaseStatus
- DatafileAutoGrowthType
- DisabledIndex
- DuplicateIndex
- FileGroupBalanced
- FKCKTrusted
- FutureFileGrowth
- GuestUserConnect
- IdentityUsage
- InvalidDatabaseOwner
- LastDiffBackup
- LastFullBackup
- LastGoodCheckDb
- LastLogBackup
- LogfileCount
- LogfilePercentUsed
- LogfileSize
- MaxDopDatabase
- OrphanedUser
- PageVerify
- PseudoSimple
- QueryStoreDisabled
- QueryStoreEnabled
- RecoveryModel
- SuspectPage
- SymmetricKeyEncryptionLevel
- TestLastBackup
- TestLastBackupVerifyOnly
- Trustworthy
- UnusedIndex
- ValidDatabaseOwner
- VirtualLogFile