For our scenario let’s opt for the first one as we want to make all detected drives as part of a SQL Cluster install are included in the Backup job.Īt this point we can specify the storage where to save this backup or in other words a Backup Repository. In the Backup mode we can choose between Entire computer and Volume level backup. This means all computer nodes in this group will be automatically managed by Veeam Backup Server. In the list of computers we can now add the Protection Group as per previous article. I like to add the prefix Agent to immediately distinguish this one from the other backup jobs. Same applies in Server mode whereas for Workstation we can still choose between the two.Īt this point let’s give a name and a description similar to the one in the screenshot below. Which is sensible considering the SQL Cluster in this case will be permanently connected with the Veeam Backup Server. This option only allows to be managed by the Backup Server. Let’s see a SQL Cluster Backup job in action!įrom the Protection Group we have created let’s do a right click and Add to backup job > windows > new job.Ī new wizard is starting and for our scenario we’ll go for the third option “Failover cluster”. Last but not least from the very same Backup data set we use the Veeam Explorer for SQL to perform an in place and out of place restores.
Moreover in the case of Microsoft SQL Backup we can decide if and how to truncate the logs choosing to own the SQL Databases Backup chain as well. When the latter works on data blocks, the former is interacting with Microsoft VSS framework and by mean of application VSS writers take a Backup according to the vendor specifications.
In a nutshell this Backup mode is able to detect the current owner of the Cluster and run the Backup Job accordingly.Īnother important aspect is the option to take both application and crash consistent Backups.
The latter will make sure all detected nodes will be automatically included and make sure all storage resources attached to the nodes are included in the backup accordingly. Essentially there are three modes, Workstation, Server and Failover cluster. In this step we’ll create not only the SQL Cluster Backup Job but also tell to work in “Failover cluster” mode. To do this we are leveraging the properties from Active Directory where the SQL Cluster actually resides. In the previous step in fact we have created a Protection Group automatically listing all the nodes part of the SQL Cluster. In this article as a second part from the previous post on how to Backup SQL Failover Cluster we are now ready to create the configuration for a SQL Cluster Backup job in Veeam.