And although the CTERA is used generally for file backups, you can actually get in at an application level and conduct SQL (Structured Query Language) backups as well.
Here’s a step-by-step process for doing so:
How to Conduct SQL Backups
From the main navigation menu, click on the “Local Backup” tab, followed by the “CTERA Agents” category. Here you will see a list of all the agents you have connected to your unit, along with when the last file-level backup took place.
Click on the agent with the words: “Administrator”
A control panel will pop up for the administrator agent. On the left-hand side of the panel will be several tabs. Scroll down until you find the one called “File-level Backup.”
One of the options in the menu will be “Applications to Back Up.” Click on that option, and then select the dropdown arrow for the application “Microsoft SQL Server.”
This will reveal a long list of the individual servers that fall under the SQL server. Select the ones that you want to be backed up. Once you’ve finished making your selections, click “Ok” in the bottom right corner. Once the window closes, click “Save” in the bottom right corner of the administrator control panel.
You have finished your SQL backup!
Note: It never hurts to double check your SQL to ensure it;s saved properly. To do this, go back into the administrator control panel from the “CTERA Agents” category. Make sure the applications you want backed up still have a checkmark in their box. If they’re still checked off, your SQL backup is successful!