SQL Server Stretch Database

Stretch Database

Data can be split between on-premises and cloud storage. 

With Stretch Database, cold/audit data is kept in the cloud and data remains available for users to

query, might be a small amount of additional latency associated with queries. Data in the cloud is backed up automatically. 

With Stretch Database, active data is kept on-premises for maximum performance and reduce storage requirements both for data and backups (it run quicker than standard backups). 

It requires no changes to new or existing TSQL queries. 

Implement a Stretch Database 

Create a  Database Master Key

After implementing Stretch Database, you can monitor it from SQL Server  Management Studio.

This monitor shows information about both the local and Azure SQL instances, along with data migration status.

Check the status of the Stretch-enabled table (such as stretch eligible row, number of rows on-premises, and Azure SQL Stretch database) and view the event health by clicking View Stretch Database Health Event, or check event details for troubleshooting. Event details includes the error details and state. 

https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/stretch-database?view=sql-server-ver15