internal/Start-DbccCheck.ps1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
Function Start-DbccCheck
{
    [CmdletBinding(SupportsShouldProcess = $true)]
    param (
        [object]$server,
        [string]$dbname,
        [switch]$table
    )
    
    $servername = $server.name
    
    if ($Pscmdlet.ShouldProcess($sourceserver, "Running dbcc check on $dbname on $servername"))
    {
        try
        {
            if ($table)
            {
                $null = $server.databases[$dbname].CheckTables('None')
                Write-Verbose "Dbcc CheckTables finished successfully for $dbname on $servername"
            }
            else
            {
                $null = $server.Query("dbcc checkdb ([$dbname])")
                Write-Verbose "Dbcc CHECKDB finished successfully for $dbname on $servername"
            }
            return "Success"
        }
        catch
        {
            Write-Exception $_
            $inner = $_.Exception.Message
            return "Failure: $inner"
        }
    }
}