internal/Start-DbccCheck.ps1
|
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")) { if ($server.ConnectionContext.StatementTimeout = 0 -ne 0) { $server.ConnectionContext.StatementTimeout = 0 } 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 { $message = $_.Exception if ($null -ne $_.Exception.InnerException) { $message = $_.Exception.InnerException } # english cleanup only sorry try { $newmessage = ($message -split "at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql")[0] $newmessage = ($newmessage -split "Microsoft.SqlServer.Management.Common.ExecutionFailureException:")[1] $newmessage = ($newmessage -replace "An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException:").Trim() $message = $newmessage } catch { $null } return $message.Trim() } } } |