What is impressive about the back up of SQL 2016?Every launch of SQL Server delivers many new capabilities–and possibilities for something new to learn.
Every launch of SQL Server delivers many new capabilities–and possibilities for something new to learn. SQL Server 2016 is nothing new in this regards. Along with many other additional functions in SQL Server 2016, Microsoft company has spent improvements to back-up. After discovering these improvements further, I believe these functions are very much of a reasoning enabler.
Managed Backup – Enhancement
Managed back-up has been around since SQL Server 2014, and permitted an automated data base back-up to Microsoft Azure, depending on changes done in the database. This function plans, works and preserves the backups–all a DBA needs to do is specify a preservation period. In SQL Server 2014, there was not much of control for regularity. In SQL Server 2016, this has been enhanced:
System data source can be supported up.
Backup of data source in simple restoration model is possible.
A back-up routine can be personalized depending on business need rather than log utilization.
There are many things added in MSDB data source in SQL Server 2016 to manage them. They are located under new schema known as managed_backup. We can run the below question to find all things under the new schema.
All the performance of handled back-up is done by SQL Server Broker so it’s essential to make sure that SQL Broker is set to start instantly.