(SQL) Tip of the Day: SQL 2014 Smart Backup


Today’s (SQL) Tip…

SQL Server Managed Backup (also known as Smart Backup) to Windows Azure manages and automates SQL Server backups to the Windows Azure Blob storage service. The backup strategy used by SQL Server Managed Backup to Windows Azure is based on the retention period and the transaction workload on the database. SQL Server Managed Backup to Windows Azure supports point in time restore for the retention time period specified. 

SQL Server Managed Backup to Windows Azure can be enabled at the database level or at the instance level to manage all the databases on the instance of SQL Server. The SQL Server can be running on-premises or in hosted environments like the Windows Azure virtual machine. SQL Server Managed Backup to Windows Azure is recommended for SQL Server running on Windows Azure Virtual Machines.

Read the rest of the article here: http://msdn.microsoft.com/en-us/library/dn449496.aspx.


Comments (0)

Skip to main content