Take DB Offline

Take DB Offline.ps1

#region Take DB Offline
	# Set DB OFFLINE (Rollback is set to IMMEDIATE)
	$query2 = "ALTER DATABASE [" + $dbName + "] SET OFFLINE WITH ROLLBACK IMMEDIATE;"
        Write-Verbose "Taking [$dbName] Offline..." -Verbose
	Invoke-Sqlcmd -Query $query2
	# Get DB Status
	function getDBStatus ($dbName) {
		$query3 = "SELECT DATABASEPROPERTYEX('" + $dbName + "', 'Status') AS dbStatus"
		$dbStatus = Invoke-Sqlcmd -Query $query3
		return $dbStatus
	}
	# Wait until DB goes OFFLINE (which shouldn't be needed since ROLLBACK is set to IMMEDIATE)
        Write-Verbose "Getting [$dbName] status..." -Verbose
	$status = getDBStatus -dbName $dbName
        Write-Output $status
	$time = 0
	while(-not ($status.dbStatus -eq "OFFLINE")){
   		sleep 2;
		$time = $time + 2
		Write-Verbose "Still waiting on DB to go OFFLINE... ($time seconds elapsed)" -Verbose
		$status = getDBStatus -dbName $dbname    
		if ($time -gt 28) {
			break
		}
	 }
#endregion