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 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

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