SQL Server Stretch Database

Dynamically stretching SQL Server databases to Azure

Make warm and cold data available at a low cost

SQL Server Stretch Database lets you dynamically stretch warm and cold transactional data from Microsoft SQL Server 2016 to Azure. Unlike typical cold data storage, your data is always to hand. With Stretch Database, you can provide longer data retention times without breaking the bank. Rather than scaling expensive, on-premises storage, stretch data to the cloud; Azure storage can be up to 40 per cent less expensive than adding more enterprise storage. Depending on how often you’ll access the data, choose the appropriate transaction level, then scale up or down as needed. For details, visit the SQL Server Stretch Database pricing page.

Move data easily – no application changes required

Seamlessly access SQL Server data regardless of whether it’s on-premises or stretched to the cloud. You set the policy that determines where data is stored, and SQL Server moves the data in the background for you. The entire table is online and ready to query. And you don’t have to change existing queries or applications – it’s completely transparent.

Use advanced security options

Stretching your most important applications to the cloud should be secure. With Stretch Database, it is. Use with SQL Server Always Encrypted to encrypt your data in motion. Row Level Security and other advanced SQL Server security features also work with Stretch Database, enabling you to extend data to the cloud with greater peace of mind.

Streamline on-premises data maintenance

Reduce on-premises maintenance times and your storage footprint by moving data to Azure. With Stretch Database, backups for your on-premises data run faster and complete more easily than they did on the un-stretched data. Backup is automatic for stretched data, further reducing the amount of time you spend on maintenance.

Manage easily

It’s easy to turn on Stretch Database from SQL Server Management studio. Use the Azure portal to configure additional settings and choose a performance level, scaling up or down as needed while maintaining control over cost.

Related products and services


Durable, highly available and massively scalable cloud storage

Virtual Machines

Provision Windows and Linux virtual machines in minutes

SQL Database

Managed relational SQL Database-as-a-service

Test Stretch Database with your free Azure account