tests/Get-DbaSuspectPage.Tests.ps1
|
$commandname = $MyInvocation.MyCommand.Name.Replace(".ps1", "") Write-Host -Object "Running $PSCommandpath" -ForegroundColor Cyan . "$PSScriptRoot\constants.ps1" Describe "$commandname Integration Tests" -Tags "IntegrationTests" { Context "Testing if suspect pages are present" { BeforeAll { $dbname = "dbatoolsci_GetSuspectPage" $Server = Connect-DbaInstance -SqlInstance $script:instance1 $null = $Server.Query("Create Database [$dbname]") $db = Get-DbaDatabase -SqlInstance $Server -Database $dbname } AfterAll { Remove-DbaDatabase -SqlInstance $Server -Database $dbname -Confirm:$false } $null = $db.Query(" CREATE TABLE dbo.[Example] (id int); INSERT dbo.[Example] SELECT top 1000 1 FROM sys.objects") # make darn sure suspect pages show up, run twice try { $null = Invoke-DbaDatabaseCorruption -SqlInstance $script:instance1 -Database $dbname -Confirm:$false $null = $db.Query("select top 100 from example") $null = $server.Query("ALTER DATABASE $dbname SET PAGE_VERIFY CHECKSUM WITH NO_WAIT") $null = Start-DbccCheck -Server $Server -dbname $dbname -WarningAction SilentlyContinue } catch {} # should fail try { $null = Invoke-DbaDatabaseCorruption -SqlInstance $script:instance1 -Database $dbname -Confirm:$false $null = $db.Query("select top 100 from example") $null = $server.Query("ALTER DATABASE $dbname SET PAGE_VERIFY CHECKSUM WITH NO_WAIT") $null = Start-DbccCheck -Server $Server -dbname $dbname -WarningAction SilentlyContinue } catch { } # should fail $results = Get-DbaSuspectPage -SqlInstance $server It "function should find at least one record in suspect_pages table" { $results.Database -contains $dbname | Should Be $true } } } |