SQL Server 2016 Managed Backup

Play SQL Server 2016 Managed Backup


In this episode of Data Exposed, Scott Welcomes Xin Jin, a Program Manager in the SQL Server team. In this episode of Managed Backup, Xin shows us what's new with Managed Backup. Managed Backup was introduced in SQL Server 2014, so Xin is here to show us what's new with Managed Backup in SQL Server 2016.

Xin kicks things off by explaining the purposes and scenarios around backing up an on-premises database to the cloud, and then gives us an overview of the Managed Backup capabilities in SQL Server 2014. From there we learn the new Managed Backup features coming in SQL Server 2016, including support for system databases, simple recovery mode, customized backup schedules, and more!

Xin ends the episode by showing us some of the new features of Managed Backup!



The Discussion

  • User profile image

    Thanks for sharing this information!  It is great to see that in SQL 2016 there is support for backing up system databases as well as databases in simple recovery mode.  The custom schedule is also a good option because it allows for different retention management policies to be implemented based on the type and criticality of the data in the database.

    - Murli

  • User profile image

    Nice , thanks for sharing >:D

  • User profile image

    Xin Jin,

       I would like this feature to be optimized for bandwidth sensitive sites too. 
    Would it be possible to skip a backup if nothing has changed?

          Full Backup Daily, Log Backup scheduled every 2 hours. But this is a 9-5 Mon-Fri operation. Outside of those hours no data modification happens, but maybe an occasional query. 

    Could you check the LSN against the LSN of the prior Backup. And just skip the operation if not required? 
    Clearly its not a huge win for a log backups but it may reduce clutter in tables that track the backups taken. 
    Avoiding the unnecessary backups on Sat & Sun could result in a 28.5% saving in bandwidth & storage. 

    As much as we all like to get excited about 7*24 systems. There are still a large number of systems that are only active in office hours. Similarly there are tons of Reporting & DW systems that only get changed at night. 

  • User profile image

    At 6:39 in video, within SSMS it shows "Azure Storage Account" as the 2nd node in Object Explorer.

    Question: How do I connect to "Azure Storage Account" from SSMS Object Explorer? Can you please share some light on that?  Is that SQL 2016 Object Explorer?

  • User profile image

    @prasannap:You'll need to firstly download Azure Storage Explorer (http://azurestorageexplorer.codeplex.com/) and you'll magically see it appear as one of the options in Object Explorer in SSMS. Nifty little feature!

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.