Genarate DBCC SHRINKFILE command script using Powershell

Generate DBCC SHRINKFILE shrink file command in small size as time

	#Generate shrink script using Powershell
	clear
	$strDB = 'MyDB'
	$strFile = 'MyDBdata'
	$iIntveral = 1000
	$iTotal = 10000
	$iMinMB = 1001
	for ($iTotal ; $iTotal -gt $iMinMB; $iTotal=$iTotal-$iIntveral)
	{
	Write-Host ' USE ['$strDB']' `n `
	'GO' `n `
	'DBCC SHRINKFILE (N'''$strFile''' ,'$iTotal')' `n `
	'GO'
	}
	# Done

view raw Generate DBCC SHRINKFILE.ps1 hosted with ❤ by GitHub

# OUTPUT USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,10000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,9000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,8000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,7000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,6000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,5000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,4000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,3000) GO USE [ MyDB] GO DBCC SHRINKFILE (N' MyDBdata' ,2000) GO #>