Around the Storage Block
cancel
Showing results for 
Search instead for 
Did you mean: 

Rely on HP StoreOnce Backup and StoreOnce Catalyst to protect your SQL database backup

StorageExperts

Shetty.jpgBy Ashwin Shetty, Product Marketing, HP Storage

 

Database backups provide special challenges. Ask any DBA – and they will likely tell you they want to perform daily full backups and sometimes more than one full backup every day.

 

But what do you do when a full database backup takes over 12 hours to complete and the database keeps growing? Take for example, Microsoft SQL DBAs who rely on efficient, high-performing and reliable backup systems to protect data while keeping costs under control. StoreOnce Catalyst can help. HP StoreOnce Catalyst extends the data protection capabilities of HP StoreOnce appliances in SQL environments. This BURA Sunday, I'm talking about the benefits of using HP StoreOnce appliances and HP Data Protector with integrated HP StoreOnce Catalyst to protect SQL databases.

 

Just what SQL DBAs like to hear

HP StoreOnce Backup appliances deliver industry-leading backup and restore performance while protecting SQL database backup data. An important part of SQL DBAs task is to maintain a consistent set of backup data. HP Data Protector provides the data protection for multiple, heterogeneous servers and operating systems. These backup data sets can be consolidated on to a single HP StoreOnce appliance.

 

HP StoreOnce Catalyst provides application centric data protection for Microsoft SQL databases giving the SQL DBA ability to perform backups and restores from SQL Management Studio GUI or CLI to the StoreOnce Backup appliance without the need for an external backup application. This gives SQL DBAs visibility and control of database backups in addition to performance, reliability and bandwidth optimization benefits of HP StoreOnce Catalyst. Backups with StoreOnce Catalyst can be performed over Ethernet or Fibre Channel with support for full backups, incremental backups, and point in time restores. Data Restores can be performed from a local StoreOnce Backup appliance or a replicated StoreOnce Backup appliance.

SQLJ.jpg 

 

Disaster recovery with HP StoreOnce

Most enterprise customers are likely to invest in an offsite DR facility. In addition, many companies are protecting SQL database applications in remote offices where untrained IT staff are expected to manage a daily backup process- generally involving the changing of physical tapes, which is a process prone to human error. HP StoreOnce Backup allows local backup to be replicated between sites in a reliable, deduplication-optimized and automated manner using object copy functionality of HP Data Protector. This provides flexibility in data recovery in these ways:

  • SQL databases can be recovered from the remote site StoreOnce appliance to the original SQL Server.
  • In event of a total disaster of the SQL database at the source site, the backup data from the StoreOnce appliance at the remote site can be restored over the WAN to the SQL server site for complete SQL database recovery.
  • SQL databases can be recovered from the DR site HP StoreOnce appliance to a DR site redundant SQL Server. The DR site redundant SQL Server is a secondary SQL Server specifically used for DR purposes in case of local site primary SQL Server failure.

HP Data Protector utilizes object copy functionality which enables DBAs to copy from one StoreOnce appliance to a remote StoreOnce appliance without having to rehydrate the data. During the object copy session, data will be replicated from one device to another, without passing through media agent clients directly from one backup device to another. For example, when backing up SQL databases to an HP StoreOnce Backup appliance, DBAs can use the object copy option to copy the data from the StoreOnce to a remote StoreOnce.

 

The reliable data protection storage you need

As a SQL customer, you demand an efficient, reliable data growth management backup system environment while keeping costs under control. What’s more, some SQL DBAs need full control of database backup and recovery. HP StoreOnce with StoreOnce Catalyst address these requirements.

 

HP StoreOnce Backup appliances offer high performance and reliability while addressing data growth through federated deduplication technology. HP StoreOnce Catalyst gives DBAs full control of database backup and recovery. HP StoreOnce appliances integrate easily with SQL to protect important mission-critical databases. Combining SQL and HP StoreOnce appliances with HP StoreOnce Catalyst provides a comprehensive data protection solution for SQL application data.    

  

Learn more

0 Kudos
About the Author

StorageExperts

Our team of Hewlett Packard Enterprise storage experts helps you to dive deep into relevant infrastructure topics.

Comments
miller dba

I'm struggling to get this implemented right now. Not having previous experience with PowerShell is making this task near impossible. I would love it this following statement were true.

"HP StoreOnce Catalyst provides application centric data protection for Microsoft SQL databases giving the SQL DBA ability to perform backups and restores from SQL Management Studio GUI or CLI to the StoreOnce Backup appliance without the need for an external backup application."

Maybe you can direct me to a place that demonstrates how to do backups and restores from Management Studio to StoreOnce. Everything I'm reading uses PowerShell.