internal/Start-DbccCheck.ps1
|
Function Start-DbccCheck { param ( [object]$server, [string]$dbname, [switch]$table ) $server = Connect-SqlServer -SqlServer $SqlServer -SqlCredential $SqlCredential $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" } } } |