Backing up and restoring Stretch-enabled databases

Since you have delegated a part of your database to the remote Azure instance, when you perform a database backup, only local and eligible data will be backed up; remote data is the responsibility of the Azure service. By default, Azure automatically creates storage snapshots at least every 8 hours and retains them for seven days so that you can restore data to a point in time (by default, 21 points). You can change this behavior and increase the number of hours or backup frequency by using the system stored procedure sys.sp_rda_set_rpo_duration. Since the Azure service is not free, this can have additional costs.

As expected, to remotely restore a database you have to log in to the Azure ...

Get SQL Server 2017 Developer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.