July 11, 2019 Vignesh Sathiyanantham

Removing the old snapshots of the Virtual Machine is one of the easiest ways that a virtualization administrator can reclaim storage capacity in their environment. Unlike reclaiming other resources like CPU or Memory, deleting old snapshots doesn’t require downtime. Now, many of us are guilty of having snapshots that are months old, and sometimes for reasons, we can’t even remember. But unless you have a tool like vRealize Operations Manager, finding and deleting old snapshots can be a lengthy manual process. There are multiple ways to find the old/stale VM snapshots, you can leverage some smart tools like RVTools to…

May 9, 2019 Vignesh Sathiyanantham

Changing the individual database recovery model is very simple with the Microsoft SSMS. But recently in one of our Nimesa customer environments, he had 200 databases in a non-production instance and all the databases are in the simple recovery model. That user wanted to do POC of Nimesa Application-aware backup and Point in time recovery for MS SQL database server, Log backups are not possible with the simple recovery model, so I executed a small PowerShell script which changes all the databases to the FULL recovery model from the simple recovery model Get-SqlDatabase -ServerInstance NW1\CLUST2 The above Powershell command gets…

May 2, 2019 Vignesh Sathiyanantham

Creating a full backup in the SQL server using SSMS is very simple, but if you have 10’s of databases you find bit difficult to backup all databases in one go. So i write a small Powershell script which gets the list of databases and takes the backup except the system databases https://gist.github.com/asvignesh/9c2f275c9418b038022ceffa94ba2152 Run the script with Server name and the backup directory as parameters .\BackupAllDatabases.ps1 -serverName NW\CLUST -backupDirectory c:\backupdir

April 20, 2019 Vignesh Sathiyanantham

To Disable UAC on the Windows Server, change the registry value EnableLUA to 0, to change it using the powershell Set-Itemproperty -path ‘HKLM:\Software\Microsoft\Windows\CurrentVersion\policies\system’ -Name ‘EnableLUA’ -value 0 Below is the script to change on multiple Windows Machines using RemotePS https://gist.github.com/asvignesh/ae5a1ad1cf036f2481ef26f67816242d

April 19, 2019 Vignesh Sathiyanantham

  While testing our product Nimesa with Microsoft SQL Server 2016 on Microsoft Windows 2019 i hit with some scenarios my nodes in SQL cluster has some shadows, i wanted to check in all the machine and delete the shadows. What i did is, i wrote a small powershell script which connects to all the nodes in my test bed and run diskshadow command  delete shadows all  For that, First i need to enable the PowerShell Remoting on all the nodes ( My nodes are connected to active directory and all are part of Windows Failover clustering ) Enable-PSRemoting -Force…

April 10, 2019 Vignesh Sathiyanantham

Copy and Paste the following command to install this package using PowerShellGet Install-Module -Name VMware.PowerCLI If you are getting any error related to the privilege PS C:\Users\asvig> Install-Module -Name VMware.PowerCLI Install-Module : Administrator rights are required to install modules in ‘C:\Program Files\WindowsPowerShell\Modules’. Log on to the computer with an account that has Administrator rights, and then try again, or install Run with adding -Scope CurrentUser Install-Module -Name VMware.PowerCLI -Scope CurrentUser In addition to that you may need to set Execution policy to RemoteSigned Set-ExecutionPolicy -ExecutionPolicy RemoteSigned by running the above command in Administrator mode, and also import Import-Module VMware.VimAutomation.Core before…