In this article, we explain the relevance of Stretch database and discuss 4 questions that a DBA must ask himself before considering a stretch database.
Stretch Database is used for migrating cold data securely and transparently to Microsoft Azure cloud. It basically targets transactional databases by storing large amount of cold data in a bunch of tables. Here are a few questions that you should ask before using a stretch Database.
Do you want to access Availability of cost-effective cold data at all times?
Using Stretch Database Users can stretch cold or warm transactional data dynamically, to Microsoft Azure, and to SQL Azure. Unlike other cold storage options, by using Stretch Database, the user will be able to create and retrieve a query at all times, as their data will be always online.
Users can also make longer timelines for data retention without breaking the order of tables like Sales Order History. Users can utilize this cost-efficient storage option provided by Azure instead of scaling expensive storage options. Users have full control over the costs and the prize of the tiers that they can change from Azure Portal’s configure settings.
Do you want to work efficiently without making changes in your application or your queries?
Users can easily access their data whether it’s stretched in a cloud or stored on-premises. Users are responsible for selecting their preferred storage option, while SQL Server ensures to access this data in front of you whenever you need it. If you use Stretch Database, your data is always online, which makes it query-able at all times. And one great benefit that comes with Stretch Database is that the user doesn’t have to change existing applications or queries, as the location of user’s database is completely transparent with the application.
Do you want to maintain your on-premises data while streamlining?
Users can reduce the hassle of on-premises maintenance and regular storage for their data using Stretch Database. As backups for on-premises data operates faster and finishes within the maintenance window. While the backups for the cloud database run automatically. This results in saving the user’s time and energy to boost performance. This reduces users’ on-premises storage requirements, which helps in data management efficiency. Also, Microsoft Azure storage is estimated to be 80% less expensive as compared to what a user has to spend if he/she is choosing to add his entire database in on-premises SSD.
Do you want to ensure that your data stays secure, even while migrating?
Stretch Database is used for migrating cold data securely and transparently to Microsoft Azure cloud. This is one of the safest storage options available for SQL Server Databases. Users can enjoy peace of mind as they stretch their most important and precious applications to the cloud. SQL Server also has an Always Encrypted option which provides encryption security for the data in motion. This encryption will prevent anyone from accessing user database without the password, which the user can share with trusted people. Users can use Stretch Database to keep their data secure as it works well with other advanced features provided in SQL Server Security, including the RLS (Row Level Security).
Many companies are actively considering using Stretch databases along with investing in a tool that can recover Sql Server database to keep their data safe at all times.
Victor Simon is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit www.datanumen.com