{"id":2143,"date":"2014-07-21T05:46:00","date_gmt":"2014-07-21T03:46:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/"},"modified":"2014-07-21T05:46:00","modified_gmt":"2014-07-21T03:46:00","slug":"backup-an-sql-server-database-from-on-premise-to-azure","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/","title":{"rendered":"Backup a SQL Server database from On-Premise to Azure"},"content":{"rendered":"<p>SQL Server database backup &amp; restore from On-Premise to Azure is a feature introduced with SQL Server 2012 SP1 CU2. In the past, it could be used with these three tools:<\/p>\n<ul>\n<li>Transact-SQL (T-SQL)<\/li>\n<li>PowerShell<\/li>\n<li>SQL Server Management Objects (SMO)<\/li>\n<\/ul>\n<p>With SQL Server 2014, backup &amp; restore can also be enabled via SQL Server Management Studio (SSMS).<\/p>\n<h3>Concept<\/h3>\n<p>This feature is quite similar to a \u201cclassic\u201d backup &amp; restore tool. Indeed, the main different lies in the backup location. That is why you need to specify an URL, instead of a path for a disk.<\/p>\n<p>The following schema explains the main process of the feature:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Windows-Azure---Mozilla-Firefox_2.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Windows-Azure-Mozilla-Firefox_2.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Windows-Azure---Mozilla-Firefox_2.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Windows-Azure-Mozilla-Firefox_2.png\" alt=\"Windows-Azure---Mozilla-Firefox_2.png\" width=\"455\" height=\"213\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>An On-Premise database needs to be backed up<\/li>\n<li>A backup is performed to Azure<\/li>\n<li>The backup is stored in Azure<\/li>\n<li>The On-Premise database needs to be restored<\/li>\n<li>The On-Premise database is restored from the backup in Azure<\/li>\n<\/ol>\n<h3>Prerequisites<\/h3>\n<h4>Azure Account Creation<\/h4>\n<p>Obviously, the first requirement is an Azure account! To create an Azure account, go to the official <a href=\"https:\/\/azure.microsoft.com\/en-us\/\">Azure website<\/a>.<\/p>\n<h4>Azure Storage Creation<\/h4>\n<p>Once the Azure account has been set, an Azure Storage must be created. It represents the highest level of namespace for accessing the backup file stored in Azure.<\/p>\n<p>The creation requires three fields: a prefix for the storage URL, a location or an affinity group and a replication:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"azure-Storae-creation.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/azure-Storae-creation.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"azure-Storae-creation.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/azure-Storae-creation.png\" alt=\"azure-Storae-creation.png\" width=\"449\" height=\"192\" \/><\/a><\/p>\n<p>The URL provides the location of the storage, and will be used to access a future backup file.<\/p>\n<p>The location field allows to choose in which Azure storage the backup must be stored. It is recommended to choose the Azure location closest to your On-Premise server. For more information about Azure locations, see details on <a href=\"https:\/\/azure.microsoft.com\/en-us\/regions\/\">Azure Regions<\/a>.<\/p>\n<p>An affinity group is a simple way to abstract the Azure location by associating a name to it.<\/p>\n<p>A replication offers a redundancy of you storage. For more information, there is a very good msdn article on this subject named <a href=\"http:\/\/blogs.msdn.com\/b\/windowsazurestorage\/archive\/2013\/12\/04\/introducing-read-access-geo-replicated-storage-ra-grs-for-windows-azure-storage.aspx\">Windows Azure Storage Redundancy Options and Read Asses Geo Redundant Storage<\/a>.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Azure-Account-Created.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure-Account-Created.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Azure-Account-Created.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure-Account-Created.png\" alt=\"Azure-Account-Created.png\" width=\"473\" height=\"72\" \/><\/a><\/p>\n<p>Finally, the Azure storage is now created.<\/p>\n<h4>Azure Container Creation<\/h4>\n<p>A backup file will be stored in Azure Storage as a Binary Large Object (Blob). It is a file of any type and size, representing a sequence of bytes.<br \/>\nA container provides a grouping of a set of Blobs, and can contain an unlimited number of Blobs. But the Storage Account cannot exceed 100 TB.<br \/>\nAll Blobs must be in a container, so the container creation is part of the prerequisites. A container can be saw as a folder, and a blob as a file.<br \/>\nThe container&#8217;s creation should be performed on Microsoft Azure, in the Storage Account location:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Create-an-Azure-Container.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Create-an-Azure-Container.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Create-an-Azure-Container.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Create-an-Azure-Container.png\" alt=\"Create-an-Azure-Container.png\" width=\"430\" height=\"114\" \/><\/a><\/p>\n<p>The creation of a container requires two fields: a name and an access policy.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Create-an-Azure-Container2.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Create-an-Azure-Container2.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Create-an-Azure-Container2.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Create-an-Azure-Container2.png\" alt=\"Create-an-Azure-Container2.png\" width=\"290\" height=\"193\" \/><\/a><\/p>\n<p>In this example, the name of the container is \u201cbackups\u201d.<br \/>\nThe access type is set as default (private), so it can be accessed only by the account owner (Microsoft recommendation):<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Azure-container-Created.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure-container-Created.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Azure-container-Created.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure-container-Created.png\" alt=\"Azure-container-Created.png\" width=\"460\" height=\"101\" \/><\/a><\/p>\n<p>Finally, the container is created.<\/p>\n<h4>Azure Credential<\/h4>\n<p>The last prerequisite is the generation of Azure credentials on the On-Premise Instance to be able to access the Azure Storage.<br \/>\nThe credentials can either be generated by GUI or Script. In this example, the Azure credential will be generated by GUI.<br \/>\nThe credentials&#8217; creation requires three different fields: a name, an identity, and a password:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Azure-Credential-Creation.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure-Credential-Creation.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Azure-Credential-Creation.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Azure-Credential-Creation.png\" alt=\"Azure-Credential-Creation.png\" width=\"383\" height=\"180\" \/><\/a><\/p>\n<p>The identity is the name of the Storage Account which is \u201cdemodbiservices\u201d in our case.<br \/>\nThe password is one of the ACCESS KEYS of the container. It can be found in Azure, in the Manage Access Keys section of the Storage Account:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Manage-Acces-Keys.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Manage-Acces-Keys.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Manage-Acces-Keys.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Manage-Acces-Keys.png\" alt=\"Manage-Acces-Keys.png\" width=\"324\" height=\"266\" \/><\/a><\/p>\n<p>A Storage Account is composed of two access keys. The PRIMARY ACCESS KEY is commonly used as a permanent key, whereas the SECONDARY ACCESS KEY is used as a temporary key. According to the requirements, one key is preferred to the other.<\/p>\n<h3>Backup &amp; restore of the database<\/h3>\n<p>The demonstration will be performed via GUI only, to show the new feature introduced in SQL Server 2014.<\/p>\n<h4>Backup the database<\/h4>\n<p>A full database backup will be performed on the container previously created. To open the required window in SSMS, just do a \u201cclassic\u201d backup:<\/p>\n<p><span style=\"font-size: 11pt; line-height: 107%; font-family: 'Calibri','sans-serif';\"><a class=\"easyblog-thumb-preview\" title=\"Backup.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Backup.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Backup.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Backup.png\" alt=\"Backup.png\" width=\"481\" height=\"259\" \/><\/a><\/span><\/p>\n<p>As soon as the URL destination is chosen instead of the disk, new fields instantly appear.<br \/>\nThen, the Azure Credentials are required at this step in order to access the Azure Storage.<br \/>\nAnd finally, the container name must be specified to store the backup.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Backup-performed.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Backup-performed.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Backup-performed.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Backup-performed.png\" alt=\"Backup-performed.png\" width=\"479\" height=\"90\" \/><\/a><\/p>\n<p>The backup is completed successfully!<\/p>\n<h4>Restore the database<\/h4>\n<p>To restore the database, just go ahead the \u201cclassic\u201d way again. SQL Server will detect that a backup has been performed to Azur, and will ask to provide the Azure credentials:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Connect-to-Azure.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Connect-to-Azure.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Connect-to-Azure.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Connect-to-Azure.png\" alt=\"Connect-to-Azure.png\" width=\"435\" height=\"186\" \/><\/a><\/p>\n<p>Once the connection has been made, SQL Server will detect all the backups performed to Azure. Select the Full backup and then restore the database:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Restore-database.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Restore-database.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Restore-database.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Restore-database.png\" alt=\"Restore-database.png\" width=\"389\" height=\"349\" \/><\/a><\/p>\n<p>The database is successfully restored!<\/p>\n<h4>Limitations<\/h4>\n<p>There are some limitations with backing up a database to Azure Storage, such as the MAXTRANSFERSIZE and BLOCKSIZE options, which are not supported.<\/p>\n<p>For more information, see \u201cLimitations\u201d section of <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dn435916.aspx#backuptaskssms\">SQL Server Backup to URL<\/a> on TechNet.<\/p>\n<h3>Managed Backup<\/h3>\n<h4>Concept<\/h4>\n<p>Managed Backup is a new feature introduced in SQL Server 2014. It is an easy and simple way to perform, schedule, and manage backups to Azure.<br \/>\nIt automates and manages SQL Server backups based on a retention period. This retention period has a range from 1 day to 30 days.<br \/>\nIt supports point in time restore, and it is based on the system jobs (needs the Agent service started and running).<br \/>\nIt is only configurable by T-SQL, and can be enabled at the instance and\/or database level.<br \/>\nIt only performs Full and Log backups to Azure Blob Storage, for user databases in Recovery Model set to Full or Bulk-logged.<\/p>\n<h4>Execution<\/h4>\n<p>A full database backup is scheduled when:<\/p>\n<ul>\n<li>Managed backup 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<h4>Enable &amp; Configure<\/h4>\n<p>The stored procedure to be used for enabling and configuring Managed Backup is \u201csmart_admin.sp_set_db_backup\u201d.<\/p>\n<p>Here is an example on how to activate the feature for an instance or a specific database:<\/p>\n<p><samp><code><a class=\"easyblog-thumb-preview\" title=\"Managed-Backup-Code-Sample.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Managed-Backup-Code-Sample.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"Managed-Backup-Code-Sample.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Managed-Backup-Code-Sample.png\" alt=\"Managed-Backup-Code-Sample.png\" width=\"449\" height=\"135\" \/><\/a><\/code><\/samp><\/p>\n<p>Other stored procedures or functions can be used to managed and configure Managed Backup.<br \/>\nFor more information, visit the <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dn449496.aspx\">SQL Server Managed Backup to Windows Azure<\/a> in TechNet.<\/p>\n<h3>Tools<\/h3>\n<p>If the different ways to perform backups from an On-Premise environment to Azure do not meet your requirements, it is time to move to a third party tool.<\/p>\n<p>One of the best-known free tools is <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=40740\">Microsoft SQL Server Backup to Microsoft Windows Azure Tool<\/a>. However, it does not offer a significant improvement, just a friendly interface.<\/p>\n<p>Some third-party tools (most are not cost-free) offer more maneuverability and in-depth functionalities. The best known one is <a href=\"http:\/\/www.cloudberrylab.com\/azure-tools.aspx\">CloudBerry Backup for Microsoft Azure<\/a>.<\/p>\n<h3>Conclusion<\/h3>\n<p>Performing backups to Azure Storage can be very attractive because it increases the high availability of an organization by offering an alternate way to store data.<\/p>\n<p>Moreover, it offers the possiblity to restore virtually from everywhere.<\/p>\n<p>However, it is interesting to focus on the new feature Managed Backup which is very easy to configure as well as to maintain &#8211; and which responds (in most cases) to the needs of the DBAs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server database backup &amp; restore from On-Premise to Azure is a feature introduced with SQL Server 2012 SP1 CU2. In the past, it could be used with these three tools: Transact-SQL (T-SQL) PowerShell SQL Server Management Objects (SMO) With SQL Server 2014, backup &amp; restore can also be enabled via SQL Server Management Studio [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":2144,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[199],"tags":[49,51,52,213],"type_dbi":[],"class_list":["post-2143","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hardware-storage","tag-microsoft","tag-sql-server","tag-sql-server-2014","tag-windows-azure"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Backup a SQL Server database from On-Premise to Azure - dbi Blog<\/title>\n<meta name=\"description\" content=\"How to backup an SQL Server database from an On-Premise environment to Azure Blob Storage.\" \/>\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\/backup-an-sql-server-database-from-on-premise-to-azure\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup a SQL Server database from On-Premise to Azure\" \/>\n<meta property=\"og:description\" content=\"How to backup an SQL Server database from an On-Premise environment to Azure Blob Storage.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-21T03:46:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Windows-Azure-Mozilla-Firefox_2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"845\" \/>\n\t<meta property=\"og:image:height\" content=\"397\" \/>\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=\"6 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\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/\"},\"author\":{\"name\":\"Nathan Courtine\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"headline\":\"Backup a SQL Server database from On-Premise to Azure\",\"datePublished\":\"2014-07-21T03:46:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/\"},\"wordCount\":1232,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Windows-Azure-Mozilla-Firefox_2.png\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"SQL Server 2014\",\"Windows Azure\"],\"articleSection\":[\"Hardware &amp; Storage\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/\",\"name\":\"Backup a SQL Server database from On-Premise to Azure - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Windows-Azure-Mozilla-Firefox_2.png\",\"datePublished\":\"2014-07-21T03:46:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"description\":\"How to backup an SQL Server database from an On-Premise environment to Azure Blob Storage.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Windows-Azure-Mozilla-Firefox_2.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Windows-Azure-Mozilla-Firefox_2.png\",\"width\":845,\"height\":397},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/backup-an-sql-server-database-from-on-premise-to-azure\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup a SQL Server database from On-Premise to Azure\"}]},{\"@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":"Backup a SQL Server database from On-Premise to Azure - dbi Blog","description":"How to backup an SQL Server database from an On-Premise environment to Azure Blob Storage.","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\/backup-an-sql-server-database-from-on-premise-to-azure\/","og_locale":"en_US","og_type":"article","og_title":"Backup a SQL Server database from On-Premise to Azure","og_description":"How to backup an SQL Server database from an On-Premise environment to Azure Blob Storage.","og_url":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/","og_site_name":"dbi Blog","article_published_time":"2014-07-21T03:46:00+00:00","og_image":[{"width":845,"height":397,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Windows-Azure-Mozilla-Firefox_2.png","type":"image\/png"}],"author":"Nathan Courtine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Courtine","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/"},"author":{"name":"Nathan Courtine","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"headline":"Backup a SQL Server database from On-Premise to Azure","datePublished":"2014-07-21T03:46:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/"},"wordCount":1232,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Windows-Azure-Mozilla-Firefox_2.png","keywords":["Microsoft","SQL Server","SQL Server 2014","Windows Azure"],"articleSection":["Hardware &amp; Storage"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/","url":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/","name":"Backup a SQL Server database from On-Premise to Azure - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Windows-Azure-Mozilla-Firefox_2.png","datePublished":"2014-07-21T03:46:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"description":"How to backup an SQL Server database from an On-Premise environment to Azure Blob Storage.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Windows-Azure-Mozilla-Firefox_2.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Windows-Azure-Mozilla-Firefox_2.png","width":845,"height":397},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/backup-an-sql-server-database-from-on-premise-to-azure\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Backup a SQL Server database from On-Premise to Azure"}]},{"@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\/2143","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=2143"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2143\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2144"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2143"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}