September 19, 2019 Vignesh Sathiyanantham

Backup rotation/retention scheme is the how long the backup is retained on the media, many techniques have evolved over time to balance the data retention and the restoration costs. Grandfather-father-son is a very common scheme used in the backup retention strategy. In which there are three or more backup cycles such as daily, weekly and monthly. the daily backups are rotated on daily basis using FIFO mechanism, the weekly backups are rotated on a weekly basis and the monthly on a monthly or quarterly basis. Common example The hourly backup (son) are rotated on hourly with one promoted to father…

September 17, 2019 Vignesh Sathiyanantham

In today’s data center industry there is a misconception about the storage snapshot as a Backup. The main one is storage snapshots are not backup, they are just point-in-time copies. It’s unclear from where the idea came from. Backup is a collection of data stored on (usually removable) non-volatile storage media for purposes of recovery in case the original copy of data is lost or becomes inaccessible; also called a backup copy. To be useful for recovery, a backup must be made by copying the source data image when it is in a consistent state. – The SNIA ( Storage…

August 21, 2019 Vignesh Sathiyanantham

In the recent posts, I shared about taking backup and restore of database and also discussed some of the issues I have seen in the customer environment and how I fixed those in Nimesa Software Nimesa uses cloud-native / storage native snapshot technology to provide the backup, backup copy to DR site, restore on primary, restore on secondary, power and cost management everything in a single Software suite for both public cloud and the private cloud. Currently, Nimesa is available as a community AMI in the Amazon marketplace. The AWS Marketplace is a curated digital catalog that makes it easy…

August 21, 2019 Vignesh Sathiyanantham

Who uses MongoDB? Based on the online resource* there are 37,658 Companies using MongoDB, MongoDB is most often used by companies with 10-50 employees and 1M-10M dollars in revenue, and the market share is about 5.0% and also many financial services using the MongoDB Data is always critical whether its RDBMS or NoSQL or Flat files AWS EBS Volume Snapshot is block-level incremental snapshots, which is one of the best and efficient way to protect the Data in the EC2 environment, you might have read lots of posts, whitepapers about advantages of using the snapshot technology. But the Snapshots of…

August 18, 2019 Vignesh Sathiyanantham

In my previous blog, I discussed how to set up the ZFS File system in Ubuntu 18.04 and setup ZVOL for Microsoft SQL Server Databases In this post let’s discuss on how to set up the Disaster recovery plan for the Microsoft SQL Database with the ZFS replication, For that, I set up the Ubuntu 18.04 Instance in us-east-1 in availability zone us-east-1c , and ssh into the instance using the pem file Then I followed my post on ZVOL for MS SQL Database to install the ZFS on the AWS Linux Instance And then with the new volume, I…

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…

January 8, 2019 Vignesh Sathiyanantham

Nimesa Software based Data protection and copy data management solution supports Microsoft SQL Server full backup and log backup, recently we got a customer request why Nimesa is skipping the Simple recovery model database during log backup Simple recovery model doesnt support log backups. Simple recovery model database automatically reclaims the log space to keep space requirements small, essentially eliminating the need to manage the transaction log space The following features are not supported by SQL Server if your database is in Simple recovery model Log shippingAlways On or Database mirroringMedia recovery without data lossPoint-in-time restores Under the simple recovery…