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
Function Start-DbccCheck
{
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.ConnectionContext.ExecuteNonQuery("dbcc checkdb ([$dbname])")
Write-Verbose "Dbcc CHECKDB finished successfully for $dbname on $servername"
}
return "Success"
}
catch
{
Write-Exception $_
$inner = $_.Exception.Message
return "Failure: $inner"
}
}
}