{"id":1823,"date":"2013-10-24T10:00:00","date_gmt":"2013-10-24T17:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/"},"modified":"2024-01-22T22:49:07","modified_gmt":"2024-01-23T06:49:07","slug":"backup-and-restore-enhancements-in-sql-server-2014-ctp2","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/","title":{"rendered":"Backup and Restore Enhancements in SQL Server 2014 CTP2"},"content":{"rendered":"

SQL Server 2014 CTP2 includes three SQL Server Backup and Restore enhancements.\u00a0 These enhancements enable using Windows Azure for backups<\/a>, providing options to ease and automate backup management<\/a>, and improved security for backups through encryption<\/a>.\u00a0<\/p>\n

In addition, to enable backup to Windows Azure from previous versions of SQL Server, a stand-alone tool<\/a>\u00a0is now available.\u00a0 A brief description of the tool and the link to the download center is included at the end of this article.<\/p>\n

The three enhancements are described in detail below:<\/p>\n

\n<\/a>SQL Server Management Studio Support for SQL Server Backup to URL (Windows Azure storage)<\/h1>\n

Support for SQL Server backup to and restore from the Windows Azure was introduced in SQL Server 2012 SP1 CU2 with Transact-SQL, SMO and PowerShell support. In the current release, the feature is further enhanced to include UI support.\u00a0 Backup and Restore tasks, and maintenance plans now include URL as a destination option when backing up or restoring a database.<\/p>\n

Following are the UI changes in SSMS:<\/p>\n

Backup UI Changes:\u00a0<\/strong><\/h2>\n
    \n
  1. \nWhen you right click a database and select <\/span>Tasks<\/strong>, and choose <\/span>Backup<\/strong>, the <\/span>Back Up Database<\/strong> dialog that launches includes new options to support backup to Windows Azure. The dialog box has three pages, <\/span>General<\/strong>, <\/span>Media Options<\/strong>, and <\/span>Backup Options<\/strong>. The <\/span>General<\/strong> page now includes <\/span>URL<\/strong> as one of the destination options.\u00a0<\/span>\n<\/li>\n<\/ol>\n

    \"Backup<\/a><\/p>\n

      \n
        \n
      1. \nFile Name:<\/strong> Name of the backup file.<\/li>\n
      2. \nSQL Credential:<\/strong>\u00a0 You can either specify an existing SQL Server Credential or create a new one by clicking the Create\u2026<\/strong> button. \u00a0The new dialog that opens when you click create requires a management certificate or a publishing profile for the Azure subscription. If you do not have access to the management certificate or publishing profile, you can create a credential by specifying the Windows Azure storage account name and access keys.\u00a0 In SSMS, from the instance, right click Security<\/strong>, select New<\/strong>, and select Credential<\/strong> to create a new SQL Credential.<\/li>\n
      3. \nAzure storage container:<\/strong> The name of the Azure storage container.<\/li>\n
      4. \nURL prefix:<\/strong> This is generated automatically using the information you provide in the above fields.\u00a0 You don\u2019t have to edit the information in this field. If however, you do, make sure it matches with the other information. For example. If you manually edit the storage URL, then the SQL Credential should have the authentication information for the storage specified.<\/li>\n<\/ol>\n<\/ol>\n

        2. \u00a0If you click the <\/span>Create…<\/strong> button, you will see a new dialog titled <\/span>Backup to URL \u2013 Create Credential\u00a0<\/strong>as shown below.<\/span><\/p>\n

        \"Create<\/a>
        <\/span><\/p>\n

          \n
            \n
          1. \nSQL Credential:<\/strong> Enter the name for the new SQL credential.\u00a0 This credential is used by SQL Server to authenticate to the Windows Azure storage account.<\/span>\n<\/li>\n
          2. \nWindows Azure Credentials:<\/strong>\u00a0 When using this dialog to create a credential, you must provide a Windows Azure Management Certificate added to the local certificate store or a publishing profile downloaded to your computer to validate the subscription and the storage account information.\u00a0 If you use the publishing profile, the subscription and the certificate are automatically populated.<\/span>\n<\/li>\n
          3. Select, type, or paste your Windows Azure subscription ID that matches the management certificate from the local certificate store.\u00a0<\/span><\/li>\n
          4. \nStorage Account:<\/strong> Select the account you want to use for storing the backups. The system stores this information in the SQL Credential that is created when you click <\/span>Create<\/strong>.<\/span>\n<\/li>\n<\/ol>\n<\/ol>\n

            3. \u00a0When you select <\/span>URL<\/strong> as the destination, you will only see certain options enabled on the <\/span>Media Options<\/strong> page. If you want to overwrite a backup stored in Windows Azure storage, you can do so using Transact-SQL using the WITH FORMAT option.<\/span><\/p>\n

            \u00a0\"Transact<\/a><\/p>\n

            Maintenance Plan Wizard has similar changes to the Define a Backup<\/strong> Page to support backup to Windows Azure storage.<\/p>\n

            Restore UI Changes:\u00a0<\/h2>\n

            In the Restore task, you now have the option of selecting URL<\/strong> as the device to restore from.\u00a0 If you select URL, you are asked to specify the SQL Credential to authenticate to the Windows Azure storage.\u00a0<\/p>\n

              \n
            1. When you select Device<\/strong> on the General<\/strong> page of the Restore task, the Backup Devices dialog that launches includes URL<\/strong> as a backup media Type.<\/li>\n<\/ol>\n

              \u00a0<\/span>\"\"<\/a><\/p>\n

              2. \u00a0When you select <\/span>URL<\/strong> as the media type and click <\/span>Add<\/strong>, you see a new dialog\u00a0 –<\/span>Connect to Windows Azure Storage<\/strong>, which allows you to specify the SQL Credential to authenticate to the storage account.<\/span><\/p>\n

              \"\"<\/a><\/div>\n
              \u00a0<\/div>\n
              3. \u00a0Once connected to the storage,\u00a0 the backup files are retrieved from the storage.<\/span><\/div>\n

              \u00a0\"\"<\/a><\/p>\n

              Here is the link to the topic that describes the feature in detail: \u00a0SQL Server Backup to URL<\/a><\/p>\n

              \n<\/a>SQL Server Managed Backup to Windows Azure Storage<\/h1>\n

              Built on top of the SQL Server Backup to URL technology, SQL Server 2014 CTP2 includes the option to let SQL Server create and manage the backup strategy. SQL Server creates a backup strategy intelligently, one that is based on recoverability to a point in time within the specified retention period and transaction activity on the database. The destination for the backup file is Windows Azure Storage.\u00a0 Once you configure this feature either for a database or for an entire instance, SQL Server manages the backup frequency for full and log backups.\u00a0 It supports point in time restore based on the retention time period you specify when configuring SQL Server Managed Backup. It also supports the use of encryption.\u00a0 Encryption is also a new feature released in SQL Server 2014 CTP2 and is described later in this blog post.<\/p>\n

              Following are sample Transact-SQL statements for configuring SQL Server Managed Backup to Windows Azure.\u00a0<\/span><\/p>\n

              For a database:<\/p>\n

              Use msdb;
               GO
               EXEC smart_admin.sp_set_db_backup 
               @database_name='TestDB' 
               ,@enable_backup=1
               ,@retention_days =30 
               ,@credential_name ='MyCredential'
               ,@encryption_algorithm ='AES_256'
               ,@encryptor_type= 'Certificate'
               ,@encryptor_name='MyServerCert01';
               GO
              <\/code><\/pre>\n
              For an instance of SQL Server:<\/p>\n
              Use msdb;
               GO
               EXEC smart_admin.sp_set_instance_backup
               @enable_backup=1
               ,@retention_days=30 
               ,@credential_name='sqlbackuptoURL',
               ,@encryption_algorithm ='AES_128'
               ,@encryptor_type= 'Certificate'
               ,@encryptor_name='MyBackupCert';

               GO
              <\/code><\/pre>\n
              Important: <\/strong>To create a backup certificate to use when configuring smart backup, use the steps described in the Encrypted Backup section below.<\/strong><\/p>\n
              Here is the link to the topic that describes the feature in detail: \u00a0SQL Server Managed Backup to Windows Azure<\/a><\/p>\n
              \n<\/a>Encrypted Backup<\/h1>\n
              To secure you backup data, you can now select to encrypt when you create a backup.\u00a0 The encryption options include an encryption algorithm and a certificate or asymmetric key to be used for the encryption.\u00a0 Only asymmetric keys residing in the Extended Key Management is supported.<\/p>\n
              Multiple encryption algorithms up to AES 256 bit are supported giving you a variety of algorithms to choose from. Adding backup encryption to a TDE encrypted database, gives additional protection for your data.\u00a0<\/p>\n
              You can control the process using Transact-SQL, SMO, PowerShell, or SSMS. Encryption options can also be used when configuring SQL Server Managed Backup to Windows Azure, therefore providing additional security for your off-site data.<\/p>\n
              It is very important that the certificate or key used for encrypting must be backed up to a different location than the backup that the certificate or key is used to encrypt.\u00a0 Without this certificate or key the backup file cannot be restored.<\/p>\n
              Important<\/strong>: Restore validates the thumbprint of the certificate during the restore operation. Therefore, the certificate used to create the backup must be retained in its original state.\u00a0 Renewing the expiry date for example changes the thumbprint and thus can render the certificate unusable.<\/p>\n
              Below are some simple steps you can follow to test out the feature.\u00a0<\/p>\n
              1. \u00a0Create a Database Master Key for the master database on the instance<\/span><\/p>\n
              \n
              USE master; 
               GO 
               CREATE MASTER KEY ENCRYPTION BY PASSWORD = '23987hxJ#KL95234nl0zBef'; 
              <\/code><\/pre>\n<\/div>\n
              2. \u00a0Create an encryption certificate\u00a0<\/span><\/p>\n
              Use Master 
               GO 
               CREATE CERTIFICATE MyTestDBBackupEncryptCert 
               WITH SUBJECT = 'MyTestDB Backup Encryption Certificate'; 
              <\/code>\u00a0<\/span><\/pre>\n
              3. Backup a database and choose the encryption option, specify an encryption algorithm, specify the certificate to use.<\/span><\/pre>\n
              BACKUP DATABASE [MyTestDB] 
               TO DISK = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL12.MSSQLSERVER\\MSSQL\\Backup\\MyTestDB.bak' 
               WITH 
               ENCRYPTION 
               ( 
               ALGORITHM = AES_256, 
               SERVER CERTIFICATE = MyTestDBBackupEncryptCert 
               ), 
               STATS = 10 
               GO
              <\/code><\/pre>\n
              Backup UI Changes:<\/h2>\n
              The Backup Options page of the Back Up Database<\/strong> Task dialog has the new encryption options.<\/p>\n
              \u00a0\"\"<\/a><\/p>\n
              \u00a0Maintenance Plan Wizard has similar changes to the\u00a0Define a Backup<\/strong>\u00a0Page to support backup to Windows Azure storage.<\/p>\n
              Here is the topic that describes the feature in detail: \u00a0Backup Encryption<\/a>\u00a0<\/span><\/p>\n
              \n<\/a>SQL Server Backup to Windows Azure Tool<\/h2>\n
              This stand-alone tool can be configured to redirect SQL Server backups to Windows Azure storage.\u00a0 To be used for SQL Server versions that do not have the built in ability to backup to Windows Azure, it also includes the options to encrypt and compress during backup.<\/p>\n
              For more information, see the download page<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
              SQL Server 2014 CTP2 includes three SQL Server Backup and Restore enhancements.\u00a0 These enhancements enable using Windows Azure for backups, providing options to ease and automate backup management, and improved security for backups through encryption.\u00a0 In addition, to enable backup to Windows Azure from previous versions of SQL Server, a stand-alone tool\u00a0is now available.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-1823","post","type-post","status-publish","format-standard","hentry","content-type-updates"],"yoast_head":"\nBackup and Restore Enhancements in SQL Server 2014 CTP2 - Microsoft SQL Server Blog<\/title>\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.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup and Restore Enhancements in SQL Server 2014 CTP2 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2014 CTP2 includes three SQL Server Backup and Restore enhancements.\u00a0 These enhancements enable using Windows Azure for backups, providing options to ease and automate backup management, and improved security for backups through encryption.\u00a0 In addition, to enable backup to Windows Azure from previous versions of SQL Server, a stand-alone tool\u00a0is now available.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-24T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7725.Back20Up20Database.png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Backup and Restore Enhancements in SQL Server 2014 CTP2\",\"datePublished\":\"2013-10-24T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/\"},\"wordCount\":1285,\"commentCount\":12,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7725.Back20Up20Database.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/\",\"name\":\"Backup and Restore Enhancements in SQL Server 2014 CTP2 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7725.Back20Up20Database.png\",\"datePublished\":\"2013-10-24T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7725.Back20Up20Database.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7725.Back20Up20Database.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup and Restore Enhancements in SQL Server 2014 CTP2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Backup and Restore Enhancements in SQL Server 2014 CTP2 - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/","og_locale":"en_US","og_type":"article","og_title":"Backup and Restore Enhancements in SQL Server 2014 CTP2 - Microsoft SQL Server Blog","og_description":"SQL Server 2014 CTP2 includes three SQL Server Backup and Restore enhancements.\u00a0 These enhancements enable using Windows Azure for backups, providing options to ease and automate backup management, and improved security for backups through encryption.\u00a0 In addition, to enable backup to Windows Azure from previous versions of SQL Server, a stand-alone tool\u00a0is now available.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2013-10-24T17:00:00+00:00","article_modified_time":"2024-01-23T06:49:07+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7725.Back20Up20Database.png","type":"","width":"","height":""}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Backup and Restore Enhancements in SQL Server 2014 CTP2","datePublished":"2013-10-24T17:00:00+00:00","dateModified":"2024-01-23T06:49:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/"},"wordCount":1285,"commentCount":12,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7725.Back20Up20Database.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/","name":"Backup and Restore Enhancements in SQL Server 2014 CTP2 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7725.Back20Up20Database.png","datePublished":"2013-10-24T17:00:00+00:00","dateModified":"2024-01-23T06:49:07+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7725.Back20Up20Database.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/7725.Back20Up20Database.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/24\/backup-and-restore-enhancements-in-sql-server-2014-ctp2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Backup and Restore Enhancements in SQL Server 2014 CTP2"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/1823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=1823"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/1823\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=1823"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=1823"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=1823"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=1823"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=1823"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=1823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}