{"id":4236,"date":"2015-01-06T03:37:00","date_gmt":"2015-01-06T02:37:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/"},"modified":"2015-01-06T03:37:00","modified_gmt":"2015-01-06T02:37:00","slug":"managed-backup-with-sql-server-2014","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/","title":{"rendered":"Managed Backup with SQL Server 2014"},"content":{"rendered":"<p>In a previous blog post called <a href=\"\/backup-an-sql-server-database-from-on-premise-to-azure\">Backup a SQL Server database from On-Premise to Azure<\/a>, I presented the different tools to backup your on-premise databases on Azure Storage. <a href=\"#security\">SQL Server Managed Backup to Windows Azure<\/a> was one of these tools.<\/p>\n<p>In my opinion, Managed Backup is a great tool. That is why I decided to dedicate an entire blog to this feature.<\/p>\n<h3>Understanding Managed Backup<\/h3>\n<p>Managed Backup is a new feature introduced in SQL Server 2014 working with Windows Azure. This feature allows to manage and automate SQL Server backups (from your on-premise or Azure SQL Server instance), configurable by \u2026 script only (T-SQL or PowerShell)!<\/p>\n<p>Microsoft recommends to use Managed Backup for Windows Azure virtual machines.<\/p>\n<p>Managed backup only works with user databases in Full or Bulk-logged Recovery Model, and can only perform Full and Log backups.<\/p>\n<p>SQL Backups supports a point in time restore, and are stored following a retention period. This setting indicates the desired lifespan of a backup stored in Azure Storage. Once the period is reached, the backup is deleted.<\/p>\n<p>SQL Backups are scheduled following the transaction workload of the database.<\/p>\n<p>A full database backup is scheduled when:<\/p>\n<ul>\n<li>The Managed backup feature is enabled for the first time<\/li>\n<li>The log growth is 1 GB or larger<\/li>\n<li>The last full database is older than 1 week<\/li>\n<li>The log chain is broken<\/li>\n<\/ul>\n<p>A transaction log backup is scheduled when:<\/p>\n<ul>\n<li>No log backup history is available<\/li>\n<li>The log space is 5 MB or larger<\/li>\n<li>The last log backup is older than 2 hours<\/li>\n<li>A full database has been performed<\/li>\n<\/ul>\n<h3>Configuring Managed Backup<\/h3>\n<p>First, you need to activate SQL Server Agent service in order to use the feature.<\/p>\n<p>In this example, I have 3 user databases as follows:<\/p>\n<p>&nbsp;<\/p>\n<table style=\"border-collapse: collapse;\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"width: 112.25pt; border-width: 1pt medium 1pt 1pt; border-style: solid none solid solid; border-color: #4472c4 -moz-use-text-color #4472c4 #4472c4; background: none repeat scroll 0% 0% #4472c4; padding: 0in 5.4pt;\" valign=\"top\" width=\"150\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\"><strong><span style=\"color: white;\">Database Named<\/span><\/strong><\/p>\n<\/td>\n<td style=\"width: 1.25in; border-width: 1pt medium; border-style: solid none; border-color: #4472c4 -moz-use-text-color; background: none repeat scroll 0% 0% #4472c4; padding: 0in 5.4pt;\" valign=\"top\" width=\"120\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\"><strong><span style=\"color: white;\">Recovery Model<\/span><\/strong><\/p>\n<\/td>\n<td style=\"width: 99pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: #4472c4 #4472c4 #4472c4 -moz-use-text-color; background: none repeat scroll 0% 0% #4472c4; padding: 0in 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\"><strong><span style=\"color: white;\">Data Files Location<\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 112.25pt; border-right: 1pt solid #8eaadb; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color #8eaadb #8eaadb; background: none repeat scroll 0% 0% #d9e2f3; padding: 0in 5.4pt;\" valign=\"top\" width=\"150\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\">AdventureWorks2012<\/p>\n<\/td>\n<td style=\"width: 1.25in; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color #8eaadb #8eaadb -moz-use-text-color; background: none repeat scroll 0% 0% #d9e2f3; padding: 0in 5.4pt;\" valign=\"top\" width=\"120\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\">Simple<\/p>\n<\/td>\n<td style=\"width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color #8eaadb #8eaadb -moz-use-text-color; background: none repeat scroll 0% 0% #d9e2f3; padding: 0in 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\">On-premise<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 112.25pt; border-right: 1pt solid #8eaadb; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color #8eaadb #8eaadb; padding: 0in 5.4pt;\" valign=\"top\" width=\"150\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\">AdventureWorks2014<\/p>\n<\/td>\n<td style=\"width: 1.25in; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color #8eaadb #8eaadb -moz-use-text-color; padding: 0in 5.4pt;\" valign=\"top\" width=\"120\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\">Full<\/p>\n<\/td>\n<td style=\"width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color #8eaadb #8eaadb -moz-use-text-color; padding: 0in 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\">On-premise<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 112.25pt; border-right: 1pt solid #8eaadb; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color #8eaadb #8eaadb; background: none repeat scroll 0% 0% #d9e2f3; padding: 0in 5.4pt;\" valign=\"top\" width=\"150\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\">Hybriddb<\/p>\n<\/td>\n<td style=\"width: 1.25in; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color #8eaadb #8eaadb -moz-use-text-color; background: none repeat scroll 0% 0% #d9e2f3; padding: 0in 5.4pt;\" valign=\"top\" width=\"120\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\">Bulk-logged<\/p>\n<\/td>\n<td style=\"width: 99pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color #8eaadb #8eaadb -moz-use-text-color; background: none repeat scroll 0% 0% #d9e2f3; padding: 0in 5.4pt;\" valign=\"top\" width=\"132\">\n<p style=\"margin-bottom: 0.0001pt; line-height: normal;\">Azure Storage<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Managed Backup can be enabled at the instance level or database level.<\/p>\n<p>If you decide to activate the feature at the instance level, the configuration will be set for all user databases of your instance (even for databases added after the configuration).<\/p>\n<p>On the other hand, you can activate the feature for specific user databases. If the feature is also configured at the instance level, it will be overridden by the configuration at the database level.<\/p>\n<p>To configure the feature, you must provide a set of parameters:<\/p>\n<ul>\n<li>The URL of the Azure Storage<\/li>\n<li>The retention period in days<\/li>\n<li>The credential name<\/li>\n<li>The encryption algorithm<\/li>\n<\/ul>\n<p>If the encryption algorithm is not set to \u2018NO_ENCRYPTION\u2019, you also need to provide these parameters:<\/p>\n<ul>\n<li>The encryptor type<\/li>\n<li>The encryptor name<\/li>\n<\/ul>\n<p>Moreover, when you configure your Managed Backup, you need to specify if you want to activate your Managed Backup.<\/p>\n<table style=\"background-color: #ffffad; width: 630px; height: 78px; border: 0px solid #ff0000;\" border=\"0\">\n<tbody>\n<tr>\n<td>You can perform a database backup with COPY_ONLY. To do this, you need to use &#8216;smart_admin.sp_backup_on_demand&#8217; stored procedure, by specifying the database name.However, this stored procedure will use the configuration of the Managed Backup at the database level. That means you must configure and enable the Managed Backup for your database.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>We need to create a credential in order to be able to connect to Azure Storage:<\/p>\n<table style=\"background-color: #bbbbbb;\" border=\"0\">\n<tbody>\n<tr>\n<td>CREATE CREDENTIAL dbiservicesWITH IDENTITY = &#8216;dbiservices&#8217;,<\/p>\n<p>SECRET = &#8216;password&#8217;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Let\u2019s configure our Managed Backup at the instance level:<\/p>\n<table border=\"0\" align=\"left\">\n<tbody>\n<tr style=\"background-color: #bbbbbb;\">\n<td>USE msdb;GO<\/p>\n<p>EXEC smart_admin.sp_set_db_backup<\/p>\n<p>@enable_backup = 0,<\/p>\n<p>@storage_url = &#8216;https:\/\/dbiservices.blob.core.windows.net&#8217;,<\/p>\n<p>@retention_days = 15,<\/p>\n<p>@credential_name = &#8216;dbiservices&#8217;;<\/p>\n<p>@encryption_algorithm = &#8216;NO_ENCRYPTION&#8217;;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>If I want to display the instance configuration:<\/p>\n<table style=\"width: 353px; height: 76px;\" border=\"0\">\n<tbody>\n<tr style=\"background-color: #bbbbbb;\">\n<td>USE msdb;GO<\/p>\n<p>SELECT * FROM smart_admin.fn_backup_instance_config();<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Here is the result:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"display-configuration.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png\"><img decoding=\"async\" title=\"display-configuration.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png\" alt=\"display-configuration.png\" \/><\/a><\/p>\n<p>We will override the Managed Backup configuration for \u2018hybriddb\u2019 database:<\/p>\n<table style=\"background-color: #bbbbbb;\" border=\"0\">\n<tbody>\n<tr>\n<td>USE msdb;GO<\/p>\n<p>EXEC smart_admin.sp_set_db_backup<\/p>\n<p>@database_name = &#8216;hybriddb&#8217;,<\/p>\n<p>@enable_backup = 0,<\/p>\n<p>@credential_name = &#8216;dbiservices&#8217;,<\/p>\n<p>@storage_url = &#8216;https:\/\/dbiservices.blob.core.windows.net,<\/p>\n<p>@retention_days = 25,<\/p>\n<p>@encryption_algorithm = &#8216;NO_ENCRYPTION&#8217;;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>If I want to display the database configuration of all databases of the instance:<\/p>\n<table style=\"background-color: #bbbbbb;\" border=\"0\">\n<tbody>\n<tr>\n<td>USE msdb;SELECT db_name, is_managed_backup_enabled, retention_days, storage_url, encryption_algorithm<\/p>\n<p>FROM smart_admin.fn_backup_db_config(NULL)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Here is the result:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"diplay-databases-configuration.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/diplay-databases-configuration.png\"><img decoding=\"async\" title=\"diplay-databases-configuration.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/diplay-databases-configuration.png\" alt=\"diplay-databases-configuration.png\" \/><\/a><\/p>\n<p>Notice that \u2018AdventureWorks2012\u2019 database has \u2018is_managed_backup_enabled\u2019 set to \u2018NULL\u2019. Indeed, this database is not sensitive to Managed Backup because it has his Recovery Model set to Simple.<\/p>\n<p>Now, I activate the Managed Backup at the instance level:<\/p>\n<table style=\"background-color: #bbbbbb;\" border=\"0\">\n<tbody>\n<tr>\n<td>USE msdb;GO<\/p>\n<p>EXEC smart_admin.sp_set_db_backup<\/p>\n<p>@enable_backup = 1;<\/p>\n<p>GO<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Now, I activate the Managed Backup for \u2018hybriddb\u2019 database:<\/p>\n<table style=\"background-color: #bbbbbb;\" border=\"0\">\n<tbody>\n<tr>\n<td>USE msdb;GO<\/p>\n<p>EXEC smart_admin.sp_set_db_backup<\/p>\n<p>@database_name = &#8216;hybriddb&#8217;,<\/p>\n<p>@enable_backup<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>If I explore Azure Storage, I can find my backups:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"backups.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/backups.png\"><img decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"backups.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/backups.png\" alt=\"backups.png\" width=\"200\" \/><\/a><\/p>\n<h3>Conclusion<\/h3>\n<p>As I said in Introduction, Managed Backup is a great feature. Easily and quicly, you can configure and enable backups for your user databases.<\/p>\n<p>However, it has some serious limitations&#8230; We can expect Managed Backup to be extended to system databases. Moreover, we can also expect Managed Backup to allow backups from user databases in Simple Recovery Model.<\/p>\n<p>Furthermore, this feature is only available to Azure Storage. Indeed, I would like to choose my storage destination. I do not understand why we cannot back up to local disks for example.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In a previous blog post called Backup a SQL Server database from On-Premise to Azure, I presented the different tools to backup your on-premise databases on Azure Storage. SQL Server Managed Backup to Windows Azure was one of these tools. In my opinion, Managed Backup is a great tool. That is why I decided to [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":4237,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[202,49,51,52],"type_dbi":[],"class_list":["post-4236","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-backup","tag-microsoft","tag-sql-server","tag-sql-server-2014"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Managed Backup with SQL Server 2014 - dbi Blog<\/title>\n<meta name=\"description\" content=\"Managed Backup is a new feature introduced in SQL Server 2014 working with Windows Azure. This feature allows to manage and automate SQL Server backups\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Managed Backup with SQL Server 2014\" \/>\n<meta property=\"og:description\" content=\"Managed Backup is a new feature introduced in SQL Server 2014 working with Windows Azure. This feature allows to manage and automate SQL Server backups\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-01-06T02:37:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"43\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nathan Courtine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Courtine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/\"},\"author\":{\"name\":\"Nathan Courtine\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\"},\"headline\":\"Managed Backup with SQL Server 2014\",\"datePublished\":\"2015-01-06T02:37:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/\"},\"wordCount\":855,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png\",\"keywords\":[\"Backup\",\"Microsoft\",\"SQL Server\",\"SQL Server 2014\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/\",\"name\":\"Managed Backup with SQL Server 2014 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png\",\"datePublished\":\"2015-01-06T02:37:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\"},\"description\":\"Managed Backup is a new feature introduced in SQL Server 2014 working with Windows Azure. This feature allows to manage and automate SQL Server backups\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png\",\"width\":900,\"height\":43},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Managed Backup with SQL Server 2014\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\",\"name\":\"Nathan Courtine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"caption\":\"Nathan Courtine\"},\"description\":\"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Managed Backup with SQL Server 2014 - dbi Blog","description":"Managed Backup is a new feature introduced in SQL Server 2014 working with Windows Azure. This feature allows to manage and automate SQL Server backups","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/","og_locale":"en_US","og_type":"article","og_title":"Managed Backup with SQL Server 2014","og_description":"Managed Backup is a new feature introduced in SQL Server 2014 working with Windows Azure. This feature allows to manage and automate SQL Server backups","og_url":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/","og_site_name":"dbi Blog","article_published_time":"2015-01-06T02:37:00+00:00","og_image":[{"width":900,"height":43,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png","type":"image\/png"}],"author":"Nathan Courtine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Courtine","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/"},"author":{"name":"Nathan Courtine","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"headline":"Managed Backup with SQL Server 2014","datePublished":"2015-01-06T02:37:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/"},"wordCount":855,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png","keywords":["Backup","Microsoft","SQL Server","SQL Server 2014"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/","url":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/","name":"Managed Backup with SQL Server 2014 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png","datePublished":"2015-01-06T02:37:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"description":"Managed Backup is a new feature introduced in SQL Server 2014 working with Windows Azure. This feature allows to manage and automate SQL Server backups","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/display-configuration.png","width":900,"height":43},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/managed-backup-with-sql-server-2014\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Managed Backup with SQL Server 2014"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1","name":"Nathan Courtine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","caption":"Nathan Courtine"},"description":"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4236","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4236"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4236\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4237"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4236"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}