- Community Home
- >
- Storage
- >
- Around the Storage Block
- >
- Data protection for Microsoft SQL databases on HPE...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Receive email notifications
- Printer Friendly Page
- Report Inappropriate Content
Data protection for Microsoft SQL databases on HPE Nimble Storage
SQL DBA/Storage Admins love deploying SQL Server databases on HPE Nimble Storage systems. Learn how HPE StoreOnce backup systems and HPE Cloud Bank Storage can help with data protection both on and off premises.
If you ask a group of SQL data base administrators (DBAs) if backups are an easy topic, the answers might be divided halfway between yes and no. What matters more than the answers is if they have factored in โrecoveryโ as a part of how they have devised their backup and data protection strategy. The reality is, SQL backups can be a tricky topic for many DBAs.
First of all, DBAs have to find about where to dump the SQL backups. A lot of the DBAs I have talked to end up putting the backups on the same array as the production DB on a different tier of disks. But is this a good idea? (Iโll discuss later why it is not.) The DBAs also has to select an optimal backup plan among various options available: weekly Fulls + daily differential (or) weekly Fulls + daily Incremental (or) daily Fullsโto satisfy the strict backup window SLAs.
Secondly, DBAs have to experiment with a zillion backup parameters: number of backup stripes; whether or not to enable backup compression at the cost of performance; balancing the PROD DB performance so that it doesnโt drop while the SQL backups are running; storage capacity planning for hosting the backups; and schedule and retention planning for optimally using the storage.
Once the DBAs determine all of this information for an optimal backup path, they need to โverifyโ the backups on an ongoing basis by: executing drills; thinking about how to create another โoffsiteโ copy on top of backup for DR purpose; and, most important of all, determining how quickly a restore can get the data back and the the latest data can be retrieved from the backups. (Or in acronym terms: RTO and RPO.)
To put it simply: The backup process may have been streamlined but was โrecoveryโ a key part of the decision-making process? Phew! Tiring right? Donโt worry. It can get easier!
So what can DBAs conclude from this discussion?
Time for the key takeaways so far:
1. Admins should not put all their eggs in the same basket, that is, don't put your prod DB storage as well as backup on the same hardware.
Nimble array resilient architecture provides six 9โs availability and also supports on-array snapshot capabilities that can be used for instantaneous recovery purposes/active-backup use-cases (i.e. spin up a SQL database immediately from a snapshot or cloning a database from a snapshot for test-dev/QA/Reporting purposes). It is true that one can go on creating hundreds of snapshots on the Nimble array.
In spite of the arrayโs resilient architecture, is it a good idea to use yet another LUN from the same array as your production database and mount it as a NTFS/ReFS volume for your SQL maintenance plansโ backup destination? Noโbad idea! It is analogous to insuring yourself with a billion dollars and adding only yourself as the beneficiary. J A better approach to data protection would be to practice the proven 3-2-1 rule. It works and will save you in times of need. Guaranteed.
To meet this need: Introducing HPE StoreOnce backup systems as a backup target for HPE Nimble Storage systems.2. SQL backups need to be the least โoperational time spentโ for a DBA on a daily basis.
As a DBA, your time is best spent on qualitative tasks, such as database design or enabling dev teamsโrather than on operational tasks such as backup. Unfortunately, most DBAs get sucked into โtransactionalโ activities like backup instead. The last thing you need to learn is a new backup tool for doing his duties. Thatโs why itโs very important that as a DBA you donโt step outside of your โhome pitchโ to go learn something new just for backing up your environment. Hence a simple integration into SQL Server Management Studio (SSMS) is the ideal solution.
To meet this need: Introducing HPE StoreOnce Catalyst plug-in for SQL Server. Check out this link for details on this plug-in.)
And let me summarize the advantages (compelling enough to bring any DBA on board).
- Integrates right into the SQL Server Management Studio (SSMS) using extended Stored Procedures integration. CLR integration is on the roadmap.
- Requests no external backup software. Backups goes straight from SSMS into StoreOnce backup appliance on-premises. The backup protocol can either be Ethernet or Fiber Channel
- Offers StoreOnce Intelligent SQL Deduplication persona. That is, StoreOnce changes the deduplication persona from an โagnosticโ approach to a SQL specific approach for delivering much better backup performance, and deduplication ratios and hence smaller storage footprint compared to traditional SQL maintenance plan backups.
- Offers the power of source-side deduplication, automatic SQL backup striping for optimal performance and deduplication and seamless disaster recovery capability by offering on-premises StoreOnce to off-premises StoreOnce deduplicated replication (OR) on-premises StoreOnce to Public Cloud deduplicated replication capabilities entirely orchestrated from within the SSMS by the DBA.
3. The StoreOnce Catalyst plug-in for SQL Server is built with โeasy recoveryโ as the central theme.
We already discussed โrecoveryโ in times of need is the key criteria one should evaluate a backup methodology on. The recovery of the SQL Serverโwhether from an on-premises StoreOnce appliance, from an off-premises StoreOnce appliances at the DR site or from a public cloudโis designed in a way that the SQL DBA would still not need to step outside the SQL Server Management studio, irrespective of the origination of the recovery objects into the recover site. Also, in case of recovery, there is also a StoreOnce Catalyst plug-in GUI available for easy identification of the objects required to restore with a single click.
Check out this demo video so see everything discussed here working together.
I encourage you to see this demo recording of this data protection solution as presented as part of a recent BrightTalk webinar on HPE Storage Solutions for SQL Server. The SQL Server on Nimble section starts from 44m:14s if you want to get right to it.Learn more about Cloud Bank Storage for Microsoft SQL Server.
Featured articles:
- The case for and against decentralizing data for security
- 5 reasons why data backup strategies fail
- Decision guide: Public cloud versus on-prem storage
- Want to know the future of technology? Sign up for weekly insights and resources
Meet Around the Storage Block blogger Bharath Ram Ramanathan, Senior Technical Marketing Engineer, HPE Storage. Bharath is responsible for bringing a solution/application context into HPE Storageโs portfolio spanning the Primary, Secondary and Cloud Storage products in the areas of Copy Data Management, Business Continuity, Dev-Ops and Data Protection. He works closely with Presales, Sales and Channel Partners to ensure the success of HPE Storage products through training delivery, tech talks, best practice sharing, whitepaper and collateral creation, direct deal support and industry event presence. He has been with Hewlett Packard Enterprise for ~9 years.
- Back to Blog
- Newer Article
- Older Article
- haniff on: High-performance, low-latency networks for edge an...
- StorageExperts on: Configure vSphere Metro Storage Cluster with HPE N...
- haniff on: Need for speed and efficiency from high performanc...
- haniff on: Efficient networking for HPEโs Alletra cloud-nativ...
- CalvinZito on: Whatโs new in HPE SimpliVity 4.1.0
- MichaelMattsson on: HPE CSI Driver for Kubernetes v1.4.0 with expanded...
- StorageExperts on: HPE Nimble Storage dHCI Intelligent 1-Click Update...
- ORielly on: Power Loss at the Edge? Protect Your Data with New...
- viraj h on: HPE Primera Storage celebrates one year!
- Ron Dharma on: Introducing Language Bindings for HPE SimpliVity R...