IT is in constant evolution, which means IT groups are facing new challenges every day. ESG research highlights the high bar being set for them by the rest of the business, and the goals they hope technology vendors can assist them with. Those goals include making the business more secure, making workers more productive, delighting customers, and transforming the business for growth and efficiency.

At the heart of all those expectations is data, which is now the lifeblood of business. As a proof-point, improving data analytics for real-time business intelligence and customer insight was among the top-three most cited corporate initiatives that organizations surveyed by ESG believed would drive their spending in 2020 and among organizations’ top-three most cited IT focus areas for 2020.

However, respondents’ top-cited reason why their IT environments have become more complex is higher data volumes. Data provides great insights that translate to profits. But the onus is on IT to manage and protect all of that information.

The Need For Robust Backup and Recovery

The mission-critical applications that SQL supports deserve the highest levels of protection and availability. As ESG has found, people have practically no tolerance for downtime anymore.

It’s not easy for IT to eliminate downtime against a backdrop of higher data volumes and stringent data protection requirements in hybrid onsite/offsite environments, but they can mitigate the risks associated with introducing solutions such as SQL 2019 into their environments. It is possible to increase overall business resiliency against data/application unavailability. Here are some of the key attributes of a robust solution:

  • The data protection mechanisms can be sized according to need. In the case of SQL, scalability and efficiency matter.
  • Granular recovery is an important capability. Turning back the clock is of prime importance in a transactional environment.
  • Deduplication can reduce the costs associated with protection storage by reducing hardware capacity demand. Dedupe also helps to maintain satisfactory performance levels, even in environments experiencing high data growth.
  • Native application integration allows data owners to perform backup and recovery from their SQL native application and client-side deduplication.
  • Compliance and data governance capabilities are now very important as well. It is necessary for backup to support compliance with multiple regulations, including newer ones such as GDPR. During an audit, it is also often necessary to be able to demonstrate recoverability.
  • Support for multi-cloud workloads is now vital because providing an extensive cloud protection ecosystem reduces risk and cost. Organizations should strive to extend SQL data backups to the public cloud for long-term retention and cost-effective disaster recovery.
  • The ability to protect more than just SQL 2019 is going to be absolutely essential. Many organizations are maintaining a variety of legacy SQL database workloads; unification of backup should be the goal.
  • Ransomware mitigation features allow SQL database(s) to be restored to a safe point in time.

The Dell Technologies Data Protection Portfolio Is Suited for SQL Environments

  • Dell EMC Integrated Data Protection Appliances are integrated, turnkey solutions designed to reduce the complexity of managing multiple data silos, point solutions, and vendor relationships. IDPA is a converged solution that offers complete backup, replication, recovery, deduplication, instant access and restore, search and analytics, tight VMware integration, disaster recovery, and long-term retention to the cloud in a single appliance.
  • PowerProtect DD Series Appliances boast an architecture built on Intel processing and Dell PowerEdge servers. They are a good option for protecting SQL data because they raise the bar for efficiency in data management—from edge, to core, to the cloud. PowerProtect DD Series Appliances deliver great performance and efficiency, and they are capable of multi-cloud data protection. Partnered with Dell EMC PowerProtect Data Manager, Application Direct is enabled with DD Boost for SQL, which enables more backups to be created with existing resources natively; according to Dell, this means 20-40% less impact to the server, and 80-98% less LAN bandwidth consumed.
  • Dell EMC PowerProtect X400 Appliance: This appliance offering is designed to meet the changing growth requirements and protects critical SQL applications. This is a multidimensional, scale-up and scale-out all-flash performing product.
  • Dell EMC PowerProtect Data Manager: This next-generation data management platform with a sleek UI greatly simplifies the protection of critical SQL workloads.
  • RecoverPoint for Virtual Machines: If organizations are encapsulating SQL workloads within VMs, they will be able to accomplish point-in-time recoveries. Recover Point for VMs can roll back to a single transaction, almost like rewinding a tape, to any point in time.

Download this whitepaper from Dell Technologies and Intel® to learn more

To read full download the whitepaper:
Fulfilling the need for robust SQL Server backup and recovery