Understanding SQL Server 2016 Stretch Database


Microsoft SQL Server 2016, the latest edition of Microsoft’s flagship database product is now available for preview, and comes fully loaded with exciting next-generation features. With SQL Server 2016, the future of database management as we know it, is rapidly changing as the rules of data management are being re-written. One exciting new feature coming in SQL Server 2016 is the Stretch Database concept. Here is what it is and how it works.

Stretch database is a tool available in SQL Server 2016, that migrates historical data from your on-premise storage to Microsoft Azure Cloud, for long term backup. This new feature  will be beneficial to those needing to keep transactional data for long periods of time and those looking to save money on storage. Being able to seamlessly migrate data to the Microsoft Azure Cloud will give you the ability to archive data without having to change the way your applications query the data.

Is this for you?

If you can make the following statements, Stretch Database may help to meet your requirements and solve your problems.

If you’re a decision maker If you’re a DBA
I have to keep transactional data for a long time. The size of my tables is getting out of control.
Sometimes I have to query the historical data. My users say that they want access to historical data, but they only rarely use it.
I have apps, including older apps, that I don’t want to update. I have to keep buying and adding more storage.
I want to find a way to save money on storage. I can’t backup or restore such large tables within the SLA.

How Does It Work?

After you enable Stretch Database for a SQL Server instance, a database, and at least one table, it silently begins to migrate your historical data to Azure.

  • If you store historical data in a separate table, you can migrate the entire table.
  • If your table contains both historical and current data, you can specify a filter predicate to select the rows to migrate.

Stretch Database ensures that no data is lost if a failure occurs during migration. It also has retry logic to handle connection issues that may occur during migration. A dynamic management view provides the status of migration.

You can pause data migration to troubleshoot problems on the local server or to maximize the available network bandwidth.

Learn More

Microsoft SQL Serer 2016 is already out in the wild and is designed to give organizations a competitive advantage over those still using old tools. Do you want to schedule a 1 day Demo day where you and your team and learn more about SQL Server 2016, schedule a booking with us at info@lgitsmart.co.za.

2 thoughts on “Understanding SQL Server 2016 Stretch Database

  1. Pingback: Highlights From 2016 #EmpowerBiz S.A | lgit smartblog
  2. Pingback: Microsoft SQL Server Available on 1 June 2016 | lgit smartblog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s