How-to Create a Protection Job for SQL Servers
- 18 Dec 2023
- DarkLight
How-to Create a Protection Job for SQL Servers
- Updated on 18 Dec 2023
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Introduction
Expedient Service Delivery staff will perform a base configuration of a Protection Job inside the Cloud Data Protection platform. To create your own Protection Job for SQL Servers, follow the below procedure.
Prerequisite
If the standard protection policies don’t match your needs, open a ticket with the OSC and a customized policy will be created to your specifications.
Procedure
- Log in to the respective Cloud Data Protection system.
- Ensure you have installed the Cohesity Helper App.
- Ensure you have registered the SQL server.
- You should be directed to the Protection Jobs page upon logging into the cluster.
- If you are not automatically directed to this page or are on a different page, from the navigation bar at the top of the page, select the Protection → Protection Jobs tab.
- Use the + menu at the top right and select MS SQL Server.
- Provide a name for the Protection Job, and select the required Source by using the drop-down and selecting SQL Servers.
- Utilize the menu to select the servers to add to the protection job
- Select the Auto-Protect Shield to auto-protect an entire SQL server
- This is the recommended protection configuration. Auto-Protect will dynamically add and remove DBs from the backup policy based on their existence on the SQL server. This drastically lowers the management overhead of removing or adding backups and can protect against forgetting to start backups on a new DB.
- Select Add to add the VMs to the Protection Job
- Select the Auto-Protect Shield to auto-protect an entire SQL server
- Utilize the drop-down menu to specify the Protection Policy
- Note that Expedient manages Protection Policies. If you need modifications to a Protection Policy, please open a ticket with the OSC
- Utilize the drop-down menu to specify the Storage Domain. If there are multiple options, always select the one that ends in _DP to ensure you are utilizing the correct space
- The Advanced section allows you to modify additional Protection Job settings
Backup Method | Utilize the default Volume-based method For SQL instances that contain 35 or more databases, please configure the Backup Method as either File or VDI-based. |
Copy-only | Modify this configuration if full backups should not truncate logs |
Databases to Backup | Utilize this option to set any desired DB backup preferences |
End Date | Utilize this setting if you wish to stop backups by a certain date automatically |
QoS | Utilize the default Backup HDD for best performance |
Scripts | Utilize this setting to define and pre or post scripts |
Incremental after Restart | Utilize this setting to specify an incremental backup to run after a restart |
Indexing | Utilize this setting to modify what the platform indexes for recovery |
Alerts | Utilize this setting if you wish to modify defaults |
SLA | Utilize this setting if you wish to set an SLA flag manually |
- Select Protect to save your configurations.
- Check any other VM protection jobs to ensure the SQL server is excluded and, if necessary, exclude the SQL server.
- The SQL job will also protect the entire VM, so any additional jobs are unnecessary and could cause performance issues on your SQL server.
Was this article helpful?