Backup and restore a SQL 2019 Big Data Cluster using Ansible
This blog will focus on creating a backup and being able to restore that backup for a Microsoft SQL 2019 Big Data cluster using Ansible and the Pure Storage FlashArray. As you might know SQL Big Data clusters run in Kubernetes for the most part, and use multiple StatefulSets to store the data (as shown in the diagram below). But first, why did I created these Ansible playbooks? Well, have you ever experienced that moment when a colleague posts a…