Risks of Using Unsupported Versions of SQL Server
Security
SQL Server 2008/R2 will no longer receive any security updates, potentially leaving your important databases open to vulnerabilities. That is a significant risk as today’s cyberattacks are becoming more sophisticated and more frequent.
Regulatory Compliance
Compliance with various regulatory standards can also be a huge issue. Standards like HIPA, SOX, GDPR, and others require supported software to meet compliance regulations. Failure to keep your SQL Server release supported can cause your business to be out of compliance, which can result in fines and other penalties.
Microsoft Support
Microsoft’s Lifecycle Policy offers 10 years of support for the 2008 and 2008 R2 versions of SQL Server and Windows Server, which expired July 9th 2019. After Microsoft no longer services a product, it is essentially unsupported, potentially causing significant downtime for critical business functions if an unexpected failure occurs.
Aging Platform Limitations
One other consideration of using an older unsupported release of SQL Server is that using an outdated release means that you’re stuck with an older feature set that lacks all the new enhancements and productivity capabilities that are found in the newer releases.
What should you consider when migrating from SQL Server 2008/R2 to a modern data platform?
Moving SQL to Nutanix Enterprise Cloud
Ready to make a switch? Here's how you can migrate your SQL Server environment over to Nutanix.
Deploy
Set up the target OS with Calm and new SQL Server instance with Era with best-practices to the target.
Test
Execute test workloads,
queries, and confirm baselines, and change the compatibility level of your DB.
Backup
Back up original DBs on the old system; restore all original SQL Server instances and DB configurations.
Understanding the Nutanix Difference
Faster Time to Value
Quickly deploy databases in minutes with One-click management that can provision, clone, patch, refresh, and backup in just a few minutes.
Business Agility
Accelerate Dev & Test deployments through a single control plane that scales transactional & analytical databases non-disruptively with web-scale architecture.
Maximize Uptime
Slash unplanned downtime events by as much as 97% and gain non-disruptive IT operations with self-healing architecture that recovers proactively. Source.
Security
Secure database infrastructure with integrated data-at-rest encryption, micro-segmentation, & database masking.
Operational Efficiency
Invest in growth with reduced TCO by as much 60% with automated database operations and support your critical applications and business processes.
Reduced Costs
Eliminate wasteful copy data costs with efficient, integrated copy data management (CDM), snapshot, & data reduction capabilities.
Haven't upgraded off of SQL Server 2008 R2 yet? Get started now!
Best Practices for Upgrading SQL Server 2008/R2
To successfully upgrade your SQL Server instances, you need to prepare with comprehensive planning and important best practices. This guide will walk you through both.
Upgrade Options for SQL Server 2008 /R2 End-of-Support
Discover today’s most pressing data platform requirements and get key considerations for upgrading your SQL Server 2008/R2.
Already upgraded? Learn how Nutanix can optimize your databases.
Best Practices: Microsoft SQL Server 2016
Unleash the power of hyperconverged infrastructure for Microsoft SQL Server.
Datasheet: Nutanix Era
Eliminate the headache of database operations in a single click.
The Definitive Guide to Microsoft SQL Server Deployment on Nutanix
Enjoy a high-performing, reliable SQL Server deployment–without silos.
Self-Service in the Era of DBaaS
Import and launch a Calm blueprint and clones into existing Era-managed databases.
See How Customers Transformed Their Businesses with Nutanix
Subaru Canada
“Nutanix has developed a very innovative technology and a set of really great products. The high performance and ease-of-use of the Nutanix systems are unmatched in the industry today”
– Manoj Tiwary, Director of Information Technology & Business Services
Regional Airline
“We were running out of Band-Aids. Over the years, we’d put together a hodge-podge consisting of an HP blade enclosure, a Cisco Blade Center, NetApp, and Compellent. But it was management nightmare—they don’t play nice together. Getting that down to a single solution was huge.”
- Senior Systems Engineer
Lenoir City Utilities Board
"We have been able to achieve blisteringly fast speeds at the data level utilizing the clustered Nutanix architecture. Nutanix allows us to take advantage of our existing infrastructure and investments—to scale out horizontally and realize the benefits of SSD. "
– William Jason Tuttle, Enterprise Data Management and Administration
Shinsegae Corporation
“By moving to Nutanix, we have obtained better agility, more operational flexibility, less down time, higher user satisfaction, and a faster return on investment. Our IT team can now focus on other more strategic projects, not just managing our IT infrastructure.”
– Mr. Seo, Director
