AWS offers two main options for deploying SQL Server in the cloud – Elastic Compute Cloud and Relational Database Service. I lately read a few blogs and did some searches with both the types of deployment of SQL Server and…
Nimesa data protection for Pure Storage integrates tightly with Pure Storage’s snapshot, replication and clone capabilities. Nimesa enables admins to create fast, space-efficient, point-in-time virtual copies of applications and virtual machines that can be used as part of a backup…
In ubuntu 18.04 PostgreSQL is running on the default directory /usr/lib/postgresql/ and the data directory is ‘/etc/postgresql/10/main’ To get the data directory you can run To change the data directory, first, stop the PostgreSQL service I mounted a ZFS volume…
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…
Amazon EBS enables users to backup volumes ar any time using EBS snapshots, Snapshots retain the data from all completed I/O operations, allowing you to restore the volume to its exact state at the moment before backup (referred to as…
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…
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…
When I am setting up the Disaster recovery plan for the MS SQL Databases in ZFS Volume, I faced permission issue while running ZFS send/receive command from a non-root account So my sender is vignesh and the receiver is ubuntu…
RAID with any filesystem / Storage array or with JBOD it comes with three main benefits. Performance Capacity Integrity Performance is how fast you can access the data / write the data into the filesystem and it is measured with…
In this post, we will see how to install ZFS on Ubuntu and present a ZVOL through iSCSI protocol to a Windows Machine for SQL Database First I created a Linux Ubuntu x64 Virtual Machine and installed the Ubuntu 18.04…
