Hi all, In our company we have lots of Dell servers. And from each server you want to know when the warranty will expire. So you can update the warranty or make plans to buy new servers and replace them… We all know that you can check the status of your warranty on the dell […]
Hi, Need to migrate a standalone Hyper-v host? Here is a powershell workflow that could help you. Run this script from the source host
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
workflow Livemigrate { param( [string]$DestinationHostname, [string]$StoragePath, [int]$throttlelimit ) if(!$throttlelimit){$throttlelimit = '2'} #removes \ at the end if ($StoragePath.EndsWith("\") -eq $true){$StoragePath = $StoragePath.Substring(0,$StoragePath.Length-1)} #replaces \\ for \ $StoragePath = $StoragePath.Replace("\\","\") #correct the start of the UNC in all cases $StoragePath = $StoragePath.TrimStart("\") $StoragePath = $StoragePath.Insert(0,"\\") $VMnames = Get-VM foreach -parallel -throttlelimit $throttlelimit ($virtualMachine in $VMnames){ $VMName = $virtualMachine.VMName $DestinationStoragePath = "$StoragePath\$VMName" Move-VM -IncludeStorage -DestinationHost $DestinationHostname -name $VMName -DestinationStoragePath $DestinationStoragePath } } Livemigrate -DestinationHostname 'HVHost02' -StoragePath 'D:\VirtualMachines' -throttlelimit 3 |
throttlelimit parameter, make sure you have enough bandwidth when you migrate the VM’s. Based on my experience on a 1Gb link you can do 2 parallel machine without interfering the […]
Recently I found a very interesting blog about an automated installation of a RDS Session Host farm 2016 from @citrixguyblog: https://citrixguyblog.com/2017/12/05/powershell-create-a-fully-automated-rds-farm-2016-with-ha-and-gateway-in-25-minutes/ I thought this is cool and exactly what I was looking for! So setup my home lab for HA mode. • 2x RDS Session Host • 2x RDS Broker • 2x RDS WebAccess • […]
When you try to create a mailbox and you see this error: New-Mailbox : ExchangeGuid is mandatory on UserMailbox. Property Name: ExchangeGuid Make sure that the “Rus Agent” is running.
|
1 2 |
Get-CmdletExtensionAgent | ? {$_.name -like "*rus agent*"} Enable-CmdletExtensionAgent "RUS agent" |
The Rus Agent adds the missing attributes in this case your ExchangeGuid to your AD account!
No featured image added.
During some stress tests on our platform we wanted to know more about the maximum and average network usage. *************************************************************** IMPORTANT before getting performance data: (same behavior for your VM’s!!!) This can affect your outcome! (Always grab the information during the real-time period) Real-time vs. Historical Data Real-time Data The Real-time data is displayed for […]
No featured image added.
Is it a bug or is it by design? Maybe I do something wrong… Please let me know I will update the blog 🙂 I did the tests with nested VM’s! Ok than… I was testing some basis things with creating Nano server images. After creating the image with a VHDX file I created a new VM: […]
No featured image added.
Hello everybody, I was looking for a solution to create a DFS namespace (DFSN) folder structure. This because I wanted to create a shares folder and in that folder my shares and its target paths. So I was looking on the internet how to do that, but I couldn’t find the right answer. And of […]
No featured image added.
Hello, This is not the most beautiful script I wrote, but functional it is J The script is tested on SQL 2014. So I’m not sure if it will work on other SQL versions…
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 |
[void][Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SqlWmiManagement') $computer = 'localhost' $sqlserver = New-Object Microsoft.SqlServer.Management.Smo.Server $computer #new data (mdf) and log (ldf) file location $NewDataLoc = 'D:\SQLData' $NewLogLoc = 'D:\SQLLog' #check if the path is typed correctly, without a \ at the end if ($NewDataLoc.EndsWith('\') -eq $true){$NewDataLoc = $NewDataLoc.Substring(0,$NewDataLoc.Length-1)} if ($NewLogLoc.EndsWith('\') -eq $true){$NewLogLoc = $NewLogLoc.Substring(0,$NewLogLoc.Length-1)} #In some cases a DBA wants to locate the log file on an other disk. So that is why you have to add the path here as well $NewTempDataLoc = "D:\SQLData" $NewTempLogLoc = "D:\SQLLog" #check if the path is typed correctly, without a \ at the end if ($NewTempDataLoc.EndsWith('\') -eq $true){$NewTempDataLoc = $NewTempDataLoc.Substring(0,$NewTempDataLoc.Length-1)} if ($NewTempLogLoc.EndsWith('\') -eq $true){$NewTempLogLoc = $NewTempLogLoc.Substring(0,$NewTempLogLoc.Length-1)} #region Master DB $masterdb = $sqlserver.Databases.Item('master') $mastermdf = ($masterdb.FileGroups).files.FileName $masterldf = ($masterdb.LogFiles).filename $masterMDFname = $mastermdf.Split('\')[-1] $masterMDFDest = $NewDataLoc + '\' + $masterMDFname $masterLDFname = $masterldf.Split('\')[-1] $masterLDFDest = $NewLogLoc + '\' + $masterLDFname #Source: http://www.mikefal.net/2015/12/09/moving-your-master-database-with-powershell/ $server = New-Object Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer $startup = $server.Services | ? {$_.name -like 'MSSQL*'} $parameters = $startup.StartupParameters.Split(';') $Errorlog = $parameters | ? {$_ -match '-e'} $set = @("-d$masterMDFDest","$Errorlog","-l$masterLDFDest") $startup.startupparameters = $set -join ';' $startup.alter() $startup.Stop() sleep 10 #if ($startup.ServiceState -eq 'running'){$startup.Stop(); sleep 10} Move-Item -Path $mastermdf -Destination $NewDataLoc -Force Move-Item -Path $masterldf -Destination $NewLogLoc -Force $startup.Start() $sqlserver.ConnectionContext.Disconnect() #endregion #region sysdatabases $sysDBs = @('msdb','model') foreach ($sysDB in $sysDBs){ $db = $sqlserver.Databases.Item("$sysDB") $dbmdf = ($db.FileGroups).files.FileName $dbldf = ($db.LogFiles).filename $dbMDFname = $dbmdf.Split('\')[-1] $dbMDFDest = $NewDataLoc + '\' + $dbMDFname $dbLDFname = $dbldf.Split('\')[-1] $dbLDFDest = $NewLogLoc + '\' + $dbLDFname $db.LogFiles[0].FileName = $dbLDFDest ($db.FileGroups).files.FileName = $dbMDFDest $db.Alter() $server = New-Object Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer $startup = $server.Services | ? {$_.name -like 'MSSQL*'} $startup.Stop() sleep 10 #if ($startup.ServiceState -eq 'running'){$startup.Stop(); sleep 10} Move-Item -Path $dbmdf -Destination $NewDataLoc -Force Move-Item -Path $dbldf -Destination $NewLogLoc -Force $startup.Start() } #endregion #region tempDB $tempdb = $sqlserver.Databases.Item('tempdb') $tempdbmdf = ($tempdb.FileGroups).files.FileName $tempdbldf = ($tempdb.LogFiles).filename $tempdbMDFname = $tempdbmdf.Split('\')[-1] $tempdbMDFDest = $NewTempDataLoc + '\' + $tempdbMDFname $tempdbLDFname = $tempdbldf.Split('\')[-1] $tempdbLDFDest = $NewTempLogLoc + '\' + $tempdbLDFname $tempdb.LogFiles[0].FileName = $tempdbLDFDest ($tempdb.FileGroups).files.FileName = $tempdbMDFDest $tempdb.Alter() $server = New-Object Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer $startup = $server.Services | ? {$_.name -like 'MSSQL*'} $startup.Stop() sleep 10 #if ($startup.ServiceState -eq 'running'){$startup.Stop(); sleep 10} Move-Item -Path $tempdbmdf -Destination $NewTempDataLoc -Force Move-Item -Path $tempdbldf -Destination $NewTempLogLoc -Force $startup.Start() #endregion #region User Databases $Databases = $sqlserver.Databases | ? {$_.name -ne "tempdb" -and $_.name -ne "msdb" -and $_.name -ne "model" -and $_.name -ne "master"} #$Databases | select name foreach ($DB in $Databases){ $DBname = $db.Name $DBowner = $db.Owner $dbmdf = ($db.FileGroups).files.FileName $dbldf = ($db.LogFiles).filename $dbMDFname = $dbmdf.Split('\')[-1] $dbMDFDest = $NewDataLoc + '\' + $dbMDFname $dbLDFname = $dbldf.Split('\')[-1] $dbLDFDest = $NewLogLoc + '\' + $dbLDFname $sqlserver.DetachDatabase("$DBname", $FALSE, $FALSE) $datastr = $NewDataLoc + '\' + $dbMDFname $logstr = $NewLogLoc + '\' + $dbLDFname $sc = $null $sc = new-object system.collections.specialized.stringcollection $sc.Add($datastr) $sc.Add($logstr) Move-Item -Path $dbmdf -Destination $NewDataLoc -Force Move-Item -Path $dbldf -Destination $NewLogLoc -Force $sqlserver.AttachDatabase("$DBname", $sc, $DBowner, [Microsoft.SqlServer.Management.Smo.AttachOptions]::None) } #endregion |
No featured image added.
It has been a while since my last post. So this is my first for 2016 J. I will show you how you can change the advanced security settings in Active Directory with PowerShell. Off course you can do everything the default GUI. But if you have to do it more than once, this is […]