Microsoft SQL Backup Solution
-
@sreekumarpg said in Microsoft SQL Backup Solution:
@scottalanmiller Agree scott, unfortunately Management current decision is to continue the SQL in the Physical cluster and seems they have no plans to change. If possible kindly share me some details and documents which can help me to propose the same to my management for review.
Here's the better question - why is management making these calls? Are they IT? Do they understand modern IT practice?
-
@sreekumarpg said in Microsoft SQL Backup Solution:
Hello All,
I would like to get the suggestion on SQL backup Solution. Currently our environment is have two node SQL cluster with around 16 TB of Data. We are using Rapid Recovery as the Backup solution. We have upgraded our Windows Cluster to 2012 with Clustered Share Volume and the SQL Cluster to 2014.
Now we are facing issue with Rapid Recovery as its not able to understand the clustered share volume and we are not able to take the backup of our SQL storage on Block level. As per Rapid Recovery, they are not sure when they will release a version which support CSV.
We are in a situation to look into another SQL backup Solutions. Currently I am testing the Unitrends backup Virtual appliance and Its is good in backup, but I am having some issues on the retention polices as they provide only minimal policy which is on the SQL instance level.
Kindly suggest me a good backup solution for the SQL database which is having application native backup agent or CSV support , rather than block level backup. Also with the backup policy and retention policy of
Backup : - Daily Incremental and Monthly Full backup
Retention : - 2 Week incremental and Last month Full backup.Backup : Every 6 Month
Retention : Last 6th MonthBackup : Every Year
Retention : Last 2 year.If this can be achieved in Unitrends please share the details.
Thanks in Advance.
Veeam