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

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…