Objective
This article is created for users to easily understand the complete procedure involved in how to deploy, configure and test MS-SQL database backups & restores. Intention is any users with no prior knowledge of Druva Phoenix will be able to follow and complete activity without any need of assistance.
Steps:
Compatibility / Support for SQL Server Database.
Prerequisites / Requirement for SQL Server Database.
Deployment / Installation Phase for SQL Server Database.
Configuration Phase for SQL Server Database.
Testing backup and restores of SQL Server Database.
Solution:
Compatibility / Support for SQL Server Database.
It is important to understand the version of the MS-SQL Server and see if it is supported by Druva Hybrid workload, please review the support matrix and Druva's EOL policy.
How to check which SQL Server edition is supported by Hybrid Workload?
Support Matrix for MS-SQL Servers
Note : If the required MS SQL Server edition is not listed in Support matrix, this means it is not tested and supported. Express editions are not supported. For more detailed information on which Windows versions are compatible with each SQL Server release, please refer to Using SQL Server in Windows on the Microsoft website.
How to check which SQL Server edition is supported by Hybrid Workload?
Log in to the SQL Server Management Studio > on left you will see Build number or version.
With the above information collected kindly navigate to Microsoft link to find MS SQL version Latest updates and version history for SQL ServerYou can also determine which version and edition of SQL Server Database Engine is running.
Prerequisites / Requirement for SQL Server Database.
What are the requirements for MS-SQL Server databases for Hybrid Workload?
Prerequisites (Refer Point 5 & 10) SQL FAQ’sNote: You should be aware of the type of SQL(Standalone, SQL FCI, Availability Group)
Deployment / Installation Phase for SQL Server Database.
How to install and activate Druva Phoenix MS SQL Server agent?
Deploy & install (Refer Point 6, 7 & 8)Configuration Phase for SQL Server Database.
How to configure MS SQL Server database backup after installation of Druva agent?
Configure MS SQL backups (Refer point 9 & 10)Testing backup and restores of SQL Server Database.
How to test the MS SQL Server database backups after backup configuration?
Manual & schedule backups (Refer Point 11)How to test the MS SQL Server database restores after successful backups?
Test SQL Server database restores (Refer Point 8)
After successfully completing all the above mentioned steps, it indicates that you have effectively set up, implemented, and verified Druva SQL backup & restore.