May 2, 2019 Vignesh Sathiyanantham

Failure rate depends more on the number of disk blocks modified since the last snapshot of the EBS volume than the total size of the volume. EBS has a listed failure rate of 0.1% – 0.4% annually, compared to a commodity disk’s rate of 4%. At first glance, this appears to be great, but this is somewhat misleading as any real production setup will use some sort of RAID. Using a RAID 1 with two drives failing at 4% would give a failure rate of 0.16% annually, which appears to be line with EBS. As long as the failed drive…

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 20, 2019 Vignesh Sathiyanantham

We got a support case user created a backup of the Virtual Machines with MS SQL running but he cannot see the databases running on the machine We checked the added credential, it was Windows Active Directory user added to administrator groups, after we disable the UAC on the Windows Server 2019 user can able to list all the backups To Disable the UAC on Windows Server 2019 Right-click at the bottom of the Windows Server 2012 Start screen, select All apps and click Run.Enter regedit and click OK. The Registry Editor window opens.Expand HKEY_LOCAL_MACHINE > SOFTWARE > Microsoft > Windows > CurrentVersion > policies > system.Right-click EnableLUA, and then select Modify.In Value data, enter 0 and then click OK. The following message displays:You must restart your computer…

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 12, 2019 Vignesh Sathiyanantham

To do some testing of the on going release of Nimesa which do the application aware ( AppAware ) Backup of Microsoft SQL Server Cluster on SQL 2016 i created a small powershell scripts which create ( actually restores ) the databases from Adventure Works backup file Change the total and volume drive letter in the below code and run it. If you want to have Data files (.mdf ) and Log Files (.ldf) in the same volume, set the volume1 and volume2 with same value If you want to create data and log files on different volume, set different…

April 10, 2019 Vignesh Sathiyanantham

PS C:\WINDOWS\system32> Set-ExecutionPolicy RemoteSigned PS C:\WINDOWS\system32> Set-PowerCLIConfiguration -InvalidCertificateAction Ignore PS C:\WINDOWS\system32> Connect-VIServer -Server servername Get-VM -name vignesh-VM-1 | Get-AdvancedSetting -Name ‘disk.EnableUUID’ If that command returns no result or the value is false, you won’t see the disk serial number inside your OS. To Enable to DISK UUID, Refer this blog disk-serial-number-is-not-set-for-windows-server-2016-on-vmware-vsphere/

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…

January 18, 2019 Vignesh Sathiyanantham

One of our Nimesa customers get this error on Event Logs, CheckTokenMembership. hr = 0x80070005, Access is denied when he takes a consistent backup using Nimesa. We found out this error is from VSS Requestor, This happens when UAC(user account control) is active. Which blocks even the administrators group users from performing operation in admin mode. Right-click at the bottom of the Windows Server Start screen, select All apps and click Run.Enter regedit and click OK. The Registry Editor window opens.Expand HKEY_LOCAL_MACHINE > SOFTWARE > Microsoft > Windows > CurrentVersion > policies > system.Right-click EnableLUA, and then select Modify.In Value data, enter 0 and then click OK.  The following message displays:You must restart your computer to turn off User Account Control Click to restart this computer

January 18, 2019 Vignesh Sathiyanantham

When we are deploying our Nimesa Appliance and running on client environment, we noticed that there are no disk serial number for virtual disks on Windows server 2016, later we came to know that deployment of Windows Server 2016 happened using deprecated vSphere thick client As per the VMware KB article, If the VM is not created with vSphere WebClient, the advanced parameter “disk.EnableUUID” is not set. and we have noticed this issue happening only with Microsoft Windows Server 2016 not in Windows 2k12 and 2K12 R2 In this scenario, we have to set the enable the disk UUID for…