After the availability of SQL Server 2019 and Windows Server 2019, I decided to play around with that in my lab. Microsoft, owing to the new demands and other technological advancements in the software industry, has released the upgraded version of SQL Server 2017, which is the SQL server 2019. This was announced and introduced…
Microsoft SQL Server is one of the most popular enterprise database, a lot of enterprises run MS SQL Server for their mission-critical applications SQL Server database management engine is fast and stable, available on both Linux and Windows platforms and can work on cloud-based servers and local servers simultaneously. It’s owned by Microsoft and is…
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 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…
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…