BlueXP is now NetApp Console
Monitor and run hybrid cloud data services
Welcome back to part two on this demo series on SQL Server protection using NetApp Snap Center and Blue XP backup and recovery for VMs on VMC FSXN. In part one, we covered the installation of Blue XP backup and recovery for VMs. And in this part, I will demonstrate the backup of SQL databases on VMC FSX. To begin, let's launch and log to the snap center server which is installed in the same stdc. Provide your credentials and sign in. This is the dashboard of Snap Center which you may be familiar with. However, if you are new to SnapCenter, you can use the get started page to help you navigate through the SnapCenter UI. First, we need to add the FSXNS storage to Snap Center. Provide the FSX and IP and credentials which you can find inthe AWS portal. So log to the AWS, get the details, management IP and credentials, copy them. Let's go back to the snap center and fit in the data and say submit. If you want to replicate, add the secondary FSXN as well to the storage page. Next, let's add the host. To do this, you need to register the Blue XP backup and recovery for VMs OVA that was deployed earlier. Adding it as a Vspear host will help you to talk to the V center and the underlining storage. Use host type as Vspear and provide the IP address of the Blue XP backup and recovery for VMs. You will need to enter the credentials created during the deployment process. Click okay and then submit. So it will basically validate and register the vspere host. Next step is to register the SQL host that we have in the SDDDC. Select host type as Windows. Provide the host name and credentials. You can use either Windowsbased authentication or SQL authentication. For this, select plug-in Microsoft Windows and Microsoft SQL Server and click on submit. The plugins will get deployed on the host which will help you carry out backup and restore activities.While this plug-in is getting installed on the host, let's go ahead and we will add the second host to the snap center. You will also need to configure the log directory to store the transaction logs. So click on the host and configure the log directory. Let's configure it for both of the hosts.And now let's add the policy. The policy will define the retention schedule and frequency for the backups. Let's create a full backup policy first. Let's have a schedule as daily. And for rest of the policy process, I will keep things to the default. Let's move to the summary page and hit finish. Similarly, let's go ahead and create a log backup. Provide the name for the policy. Here, choose log backup. Frequency to hourly. Rest of the settings I will keep it to default. Again move to the summary page and finish.Now let's go to the resource tab. After adding the host, all the resources will be discovered and presented over here. You will be able to see the instances as well as the databases here. So let's go back to the database view and let's protect the VMC DB database. So for protection you can provide a custom name of your choice to the snapshot if you wish tocreate a policy. You can either create one on the fly or use that one that we have created in the previous step. So in this case click on the SQL full backup configure the schedule. I'm going to set it for 2:00 a.m. every day. So once you are done, click okay and configure. Let's configure it for the log backup as well. We will set it to 2:00 a.m. and for 15 minutes. Repeat for 15 minutes.So once you have done that, let's move on to the next step. I will keep it to the default. Click on the summary and click on the finish button. The backups will be triggered as per the schedule. But you can also trigger ondemand backup. So let's go ahead and click ondemand backup.Let's trigger this on demand backup for full as well as for the log backups. While both the full backup and log backups are running, take a quick look at the backup and you will be able to see all the subtasks that are happening. So once the backup is completed, you will see that there is backup available now in the snap center UI. So this number is 7068. To access the same snapshot on the FSXN login using CLI. You will now be able to see the same snapshot available on the FSX side as well. Thank you so much for watching. Please join me in part three of this demo series where I will demonstrate how to restore and clone the SQL host using NetApp Snap Center and Blue XP backup and recovery for VMs. Thank you so much.
Learn how to register FSxN storage, add BlueXP backup and recovery for VMs and SQL hosts, and protect them with a policy in the SnapCenter.