ForEach ($Select in $Selected) | |
{ | |
$Type = [int](-not $Database) | |
$Name = (Invoke-SQLQuery -Instance $Instance -Database Master -MultiSubnetFailover -Query "Select name From sys.master_files Where database_id = '$($Select.ID)' And type = $Type").Name | |
If ($Name) | |
{ | |
Write-Verbose "$(Get-Date): Shrinking $($Select.Name) database/log file: $Name" | |
$Result = Invoke-SQLQuery -Instance $Instance -Database $Select.Name -MultiSubnetFailover -Query "DBCC SHRINKFILE($Name,1)" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment