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

December 25, 2018 Vignesh Sathiyanantham

Storage capacity consumed by multiple unnecessary data copies costs businesses as much as $44 billion annually, according to IDC. It estimates that redundant copies of the same data ( copy data) account for more than 60% of enterprise disk storage capacity. The redundant copies are compounded by rational practices intended to protect the business with multiple separate copies of production data like full backups, disaster recovery copy, test and dev, data analytics All the extra storage comes at a cost, data storage isn’t cheap, businesses have to waste more money on unnecessary storage expenses. There are many Copy Data management…

December 14, 2018 Vignesh Sathiyanantham

Like every computer needs harddisk VM or Cloud Instances are no exception. In Amazon, EBS is the virtual hard disk for your EC2 instances, it stores data as blocks and it is like a traditional file system you can format it with any file system and use EBS is not a stand-alone storage, you cannot use EBS volumes like S3 and unlike VMware Virtual Disks you cannot share the EBS between instances at the same time. Until 2012 Amazon had a single type EBS volumes The magnetic standard volume then they had another two more types ( General Purpose SSD and…

July 31, 2018 Vignesh Sathiyanantham

If you’re looking into data protection solutions you’re probably have heard the phrase “3-2-1 backup”. You’ll hear it from most IT consultants, professionals as well as many backup vendors and admins. Every admin should have backups. This 3-2-1 principle works for any virtual environment regardless of the hypervisors you are running (VMware, Hyper-V or whatever). and it can effectively address any failure scenario Keep at least 3 copies of your data That includes the original copy and at least two backups. Keep the backed-up data on 2 different storage types The chances of having two failures of the same storage type…

July 7, 2018 Vignesh Sathiyanantham

Cloud Server/network outages are wrecking balls, and it can happen with a dominant market player like the Amazon Web Services (AWS), The latest is an extensive outage brought on by a human error at an AWS data center in Virginia. Many consider it to be the worst hit in four years. And in June 2016: The storms that battered Sydney also shook AWS services. An extensive power outage led to the failure of a number of Elastic Compute Cloud (EC2) instances and Elastic Block Store (EBS) volumes, many of which hosted critical workloads for big brands. The result was that…

June 22, 2018 Vignesh Sathiyanantham

Data loss can be a common experience of computer users; a 2008 survey found that 66% of respondents had lost files on their home PC. A backup refers to the copying into an archive file of computer data so it may be used to restore the original after a data loss event. If a computer system is not having active IOs to the backup directory and we copy the data to archival location then we have a good copy of backup ( consistent backup ) . If a computer system is in use while it is being backed up, the…

January 22, 2018 Vignesh Sathiyanantham 1Comment

Recently, An Indiana hospital paid a ransom of $55,000 to get rid of ransomware that had infected its systems and was hindering operations. when attackers breached the network of Hancock Health, a regional hospital in the city of Greenfield, Indiana. Hancock Health CEO Steve Long said the hackers are believed to be in eastern Europe and may have used a type of ransomware called SamSam, SamSam encrypted files and renamed them with the phrase “I’m sorry”, according to a local newspaper who broke the news. The hospital said that despite having backups it opted to pay the ransom demand of…

October 31, 2017 Vignesh Sathiyanantham

[amazon_link asins=’8126565780,B007X6SMD6,B01FGT7J3K,B007Q4XQEU,B01LX8J2S9,B01MG5IPDO,B01FSZHYSW’ template=’ProductCarousel’ store=’asvignesh-21′ marketplace=’IN’ link_id=’c40293c0-c0bb-11e7-9231-5decb318ea19′]   First stop the AWS EC2 Instance Create the EBS snapshot of the volume which you want to encrypt Copy the EBS snapshot which you created in the previous step to same availability zone and check the Encryption check box Create the new EBS volume from the encrypted EBS snapshot Now the newly created EBS volume is Encrypted Detach the root volume and attach the new Encrypted volume with the same device name ( /dev/sda1 )

February 29, 2016 Vignesh Sathiyanantham

Shadow Copies  are possible for almost all volumes and not “all volumes”. There are few cases which the shadow copy may not work Enough Space The shadow storage volume must contain enough free space. At the very minimum you need at least 300 MB or so, for a single shadow copy, for multiple shadow copies, the space can increase more depending on the I/O usage. You can always run the command VSSADMIN LIST SHADOWSTORAGE to see how much space is used for the existing shadow copies. Only Fixed Drives Only fixed drives are supported. You cannot enable Shadow Copy on removable,…