{"id":14182,"date":"2019-12-10T07:29:42","date_gmt":"2019-12-10T07:29:42","guid":{"rendered":"https:\/\/dbtut.com\/?p=14182"},"modified":"2019-12-10T07:29:45","modified_gmt":"2019-12-10T07:29:45","slug":"what-is-stretch-database-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/","title":{"rendered":"What is Stretch Database in SQL Server"},"content":{"rendered":"<h2>What is Stretch Database?<\/h2>\n<p>If you want to archive your old data to Azure, all you need is StretchDatabase. You can then query as you wish your old data from Azure.<\/p>\n<p>With Stretch Database, you can reduce your disk based costs, backup costs and maintenance costs by reducing your data to grow much on your expensive systems and shorten your backup restore times.<\/p>\n<p>Most importantly, you can query the whole table in the same way without making any changes within the application.<\/p>\n<p>If data is on the Azure, it will be transmitted to the application via Azure, and if data is on your own systems it will be transmitted from your own systems to the application. The control of these operations will be handled by SQL Server.<\/p>\n<p>There are many restrictions on this feature as of now. But I think many of these restrictions will be reduced after a few releases.<\/p>\n<h2>Stretch Database Limitations<\/h2>\n<ul>\n<li>We cannot update or delete data transferred to Azure.<\/li>\n<li>We cannot insert into Stretched table via linked server.<\/li>\n<li>We cannot create an indexed view for a stretched table.<\/li>\n<li>The filters we created on the indexes in our own system cannot be transferred to the table on azure. You can find information about filtered index in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/03\/07\/what-is-filtered-index-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is Filtered Index in SQL Server<\/a>&#8220;.<\/li>\n<li>Tables with more than 1023 columns and more than 998 indexes cannot be stretched.<\/li>\n<li>File tables or tables that contain filestream data cannot be stretched. You may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/11\/what-is-file-stream-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is File Stream On SQL Server<\/a>&#8220;<\/li>\n<li>Replicated tables, tables that use Change Tracking or Change Data Capture cannot be stretched. You may want to read articles &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/03\/sql-server-replication-types\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Replication Types<\/a>&#8221;\u00a0and &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/05\/19\/change-data-capturecdc-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Change Data Capture (CDC) in SQL Server<\/a>&#8220;.<\/li>\n<li>Memory Optimized Tables cannot be stretched. You may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/05\/in-memory-oltp-in-sql-server-2014-sql-server-2016-and-sql-server-2017\/\" target=\"_blank\" rel=\"bookmark noopener noreferrer\">In Memory OLTP in SQL Server 2014, SQL Server 2016 and SQL Server 2017&#8243;<\/a><\/li>\n<li>Tables that contain data types &#8220;text, ntext, image, timestamp, sql_variant, XML, geometry, geography, hierarchyid, and CLR&#8221; cannot be stretched. You may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/13\/sql-server-data-typestsql\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Data Types<\/a>&#8220;<\/li>\n<li>Tables with COLUMN_SET cannot be stretched.<\/li>\n<li>Tables containing Computed Column cannot be stretched. You may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/26\/computed-column-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Computed Column in SQL Server<\/a>&#8220;.<\/li>\n<li>Tables with Default Constraint or Check Constraint cannot be stretched. You may want to read the articles &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/how-to-create-check-constraint\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create CHECK CONSTRAINT<\/a>&#8220;, &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/22\/what-is-constraint-and-sql-server-constraint-typestsql\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is Constraint and SQL Server Constraint Types(TSQL)<\/a>&#8221; and &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/02\/dbcc-checkconstraints-command-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">DBCC CHECKCONSTRAINTS Command On SQL Server<\/a>&#8220;.<\/li>\n<li>Parent table of Foreign Key table cannot be stretched. You may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/14\/what-is-primary-key-and-foreign-key\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is Primary Key and Foreign Key<\/a>&#8220;.<\/li>\n<li>Tables containing Fulltext Index, XML Index, Spatial Index cannot be stretched. You may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/12\/fulltext-search-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Fulltext Search On SQL Server<\/a>&#8220;.<\/li>\n<\/ul>\n<h2>Example<\/h2>\n<h3>Create a table with the following script<\/h3>\n<pre class=\"lang:default decode:true\">CREATE TABLE [dbo].[StretchTable](\n\t[ID] [int] IDENTITY(1,1) NOT NULL,\n\t[Name] [varchar](50) NULL,\n\t[Surname] [varchar](50) NULL,\n\t[DateInfo] [datetime] NULL,\n CONSTRAINT [PK_StretchTable] PRIMARY KEY CLUSTERED \n(\n\t[ID] ASC\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, \nALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\n) ON [PRIMARY]<\/pre>\n<p>Then we run the following script for 30 seconds and add some records to our table. The value of the DateInfo column is a random value between two specified dates each time.<\/p>\n<pre class=\"lang:default decode:true\">USE [Test]\nGO\nDECLARE @firstdate DATETIME = '20000101'\nDECLARE @lastdate DATETIME = '20170101'\nDECLARE @difference INT = DATEDIFF(DD,@firstdate,@lastdate)\n\nwhile(1=1)\nBEGIN\nDECLARE @randomdate datetime;\nselect @randomdate= DATEADD(DD,@difference*RAND(),@firstdate)\nINSERT INTO [dbo].[StretchTable]\n           ([Name]\n           ,[Surname]\n           ,[DateInfo])\n     VALUES\n           ('Nurullah'\n           ,'\u00c7AKIR'\n           ,@randomdate\n\t\t   )\nEND<\/pre>\n<p>Assume that we will archive the data before 2015-01-01 to azure using the stretch database feature. First , find the number of records we have inserted before 2015-01-01 with the help of the script below and note this number anywhere.<\/p>\n<pre class=\"lang:default decode:true \">SELECT Count(*)\n  FROM [Test].[dbo].[StretchTable]\n  where DateInfo&lt;'2015-01-01'\n--243968<\/pre>\n<p id=\"noDXOdL\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14184  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de8de37145c8.png\" alt=\"\" width=\"509\" height=\"314\" \/><\/p>\n<p>First, we enable Stretch Database at Instance level with the following script.<\/p>\n<pre class=\"lang:default decode:true \">EXEC sp_configure 'remote data archive', 1;\nRECONFIGURE;<\/pre>\n<p id=\"yGqMNsW\"><img loading=\"lazy\" decoding=\"async\" width=\"761\" height=\"196\" class=\"size-full wp-image-14185  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de8e8b4a3e19.png\" alt=\"\" \/><\/p>\n<p>Then right click on the database and click on Tasks-&gt;Stretch-&gt;Enable.<\/p>\n<p id=\"PnUjclu\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14187  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de8e92eb6ce4.png\" alt=\"\" width=\"707\" height=\"118\" \/><\/p>\n<p>On the screen that appears, we select our table to archive.<\/p>\n<p id=\"ibJxhUh\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14188  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de8e94d06371.png\" alt=\"\" width=\"742\" height=\"220\" \/><\/p>\n<p>We see EntireTable in the Migrate section. We don&#8217;t want to archive the whole table. We just want to archive the data before the 2015-01-01 in our table. That&#8217;s why we click EntireTable.<\/p>\n<p>In the screen that appears, click on Choose Rows as follows.<\/p>\n<p>We give a name from Name section.<\/p>\n<p>We select our column named DateInfo from the Where section.<\/p>\n<p>Select &#8220;&lt;&#8221; from the middle filter section and enter the date we want to archive in the Value section and click Check. Once you see Success, we&#8217;re done by clicking Done and Next.<\/p>\n<p id=\"GlEGJct\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"533\" class=\"size-full wp-image-14189  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de8f4df32530.png\" alt=\"\" \/><\/p>\n<p>We need to enter your Azure account on the next screen. Click Sign In\u2026.<\/p>\n<p id=\"ibquxeV\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14190  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de8f50e47797.png\" alt=\"\" width=\"713\" height=\"386\" \/><\/p>\n<p>After you sign in with your Azure account, you should see a screen like the one below.<\/p>\n<p>In this screen, I click Existing server to use the server that I created with SQL Database on Azure. See &#8220;How To Create SQL Database on Azure&#8221;.<\/p>\n<p>You can create a new server on this screen by clicking Create new server.<\/p>\n<p id=\"wMDorto\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14191  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de8f59714faf.png\" alt=\"\" width=\"773\" height=\"462\" \/><\/p>\n<p>The next screen says that a master key will be created to protect our database credentials. We are writing a password for this master key.<\/p>\n<p id=\"qYXHsZu\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"488\" class=\"size-full wp-image-14193  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de8f6149195c.png\" alt=\"\" \/><\/p>\n<p>On the next screen, we determine the IP or IP list that Azure will accept when accessing Azure from SQL Server.<\/p>\n<p>If you want to access from a single IP select &#8220;Use source SQL Server Public IP&#8221;<br \/>\nor<br \/>\nIf you want to access from an IP Range select &#8220;Use subnet IP range&#8221;<\/p>\n<p>Microsoft recommends that we use an IP range. I choose the first option because I&#8217;m testing from my own machine.<\/p>\n<p id=\"NngMvLl\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14194  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de8f6cfc0561.png\" alt=\"\" width=\"749\" height=\"315\" \/><\/p>\n<p>Finally, we see a screen like the following. Click Finish to complete the process.<\/p>\n<p id=\"dJViHjj\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-14196  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/img_5de9042db3bf5.png\" alt=\"\" width=\"615\" height=\"399\" \/><\/p>\n<p>You can learn the number of rows in local and azure by running the script below.<\/p>\n<pre class=\"lang:default decode:true\">sp_spaceused @objname = 'dbo.StretchTable', @mode = N'LOCAL_ONLY'\nsp_spaceused @objname = 'dbo.StretchTable', @mode = N'REMOTE_ONLY'<\/pre>\n<h2>Disable Stretch Database<\/h2>\n<p>If you want to Disable the Stretch Database structure, Disable option will appear in the Enable section.<\/p>\n<p>If you select &#8220;Bring Data Back From Azure&#8221; in this section, your data in Azure will be returned to your table.<\/p>\n<p>Or, if you select &#8220;Leave Data In Azure,&#8221; you&#8217;ll leave your data in Azure.<\/p>\n<p>You can access other Azure related articles by typing Azure in the Search section of our site.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14182\" class=\"pvc_stats all  \" data-element-id=\"14182\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>What is Stretch Database? If you want to archive your old data to Azure, all you need is StretchDatabase. You can then query as you wish your old data from Azure. With Stretch Database, you can reduce your disk based costs, backup costs and maintenance costs by reducing your data to grow much on your &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14182\" class=\"pvc_stats all  \" data-element-id=\"14182\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":14198,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[6589,6587,6588,6612,6610,6597,6611,6596,6599,6616,6595,6594,6600,6601,6591,6592,6604,6598,6590,6603,6602,6593,6609,6608,6614,6613,6615,6605,6606,6607],"class_list":["post-14182","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-archive-data-to-azure","tag-disable-stretch-database","tag-enable-stretch-database","tag-how-to-setup-and-use-a-sql-server-stretch-database","tag-introduction-to-stretch-database","tag-microsoft-azure-sql-server-stretch-database","tag-sql-server-2016-stretch-database","tag-sql-server-stretch-database-azure","tag-sql-server-stretch-database-limitations","tag-sql-server-stretch-databases","tag-sql-stretch-database-azure","tag-stretch-database-azure","tag-stretch-database-feature-in-sql-server","tag-stretch-database-feature-in-sql-server-2016","tag-stretch-database-in-sql-server","tag-stretch-database-in-sql-server-2016","tag-stretch-database-in-sql-server-2016-step-by-step","tag-stretch-database-limitations","tag-stretch-database-restrictions","tag-stretch-database-sql","tag-stretch-database-to-minimize-storage-costs","tag-stretch-db-in-sql-server","tag-understanding-stretch-database","tag-what-is-azure-stretch-database","tag-what-is-sql-server-stretch-database-in-azure","tag-what-is-sql-stretch-database","tag-what-is-stretch-database-in-sql-server-2016","tag-what-is-stretch-database-in-sql-server","tag-what-is-stretch-database","tag-what-is-the-use-case-where-we-can-use-stretch-database"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is Stretch Database in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"What is Stretch Database in SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Stretch Database in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"What is Stretch Database in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-10T07:29:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-10T07:29:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"558\" \/>\n\t<meta property=\"og:image:height\" content=\"325\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"What is Stretch Database in SQL Server\",\"datePublished\":\"2019-12-10T07:29:42+00:00\",\"dateModified\":\"2019-12-10T07:29:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/\"},\"wordCount\":945,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-3.png\",\"keywords\":[\"Archive data to azure\",\"Disable Stretch Database\",\"Enable Stretch Database\",\"How to setup and use a SQL Server Stretch Database\",\"Introduction to Stretch Database\",\"microsoft azure sql server stretch database\",\"SQL Server 2016 Stretch Database\",\"sql server stretch database azure\",\"sql server stretch database limitations\",\"SQL Server stretch databases\",\"sql stretch database azure\",\"stretch database azure\",\"stretch database feature in sql server\",\"stretch database feature in sql server 2016\",\"stretch database in sql server\",\"stretch database in sql server 2016\",\"stretch database in sql server 2016 step by step\",\"stretch database limitations\",\"Stretch Database Restrictions\",\"stretch database sql\",\"stretch database to minimize storage costs\",\"stretch db in sql server\",\"Understanding Stretch Database\",\"What is azure stretch database?\",\"what is sql server stretch database in azure\",\"what is sql stretch database\",\"what is stretch database in sql server 2016\",\"What is stretch database in SQL Server?\",\"What is stretch database?\",\"What is the use case where we can use stretch database?\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/\",\"name\":\"What is Stretch Database in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-3.png\",\"datePublished\":\"2019-12-10T07:29:42+00:00\",\"dateModified\":\"2019-12-10T07:29:45+00:00\",\"description\":\"What is Stretch Database in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-3.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-3.png\",\"width\":558,\"height\":325},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is Stretch Database in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Stretch Database in SQL Server - Database Tutorials","description":"What is Stretch Database in SQL Server","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:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"What is Stretch Database in SQL Server - Database Tutorials","og_description":"What is Stretch Database in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-10T07:29:42+00:00","article_modified_time":"2019-12-10T07:29:45+00:00","og_image":[{"width":558,"height":325,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-3.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"What is Stretch Database in SQL Server","datePublished":"2019-12-10T07:29:42+00:00","dateModified":"2019-12-10T07:29:45+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/"},"wordCount":945,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-3.png","keywords":["Archive data to azure","Disable Stretch Database","Enable Stretch Database","How to setup and use a SQL Server Stretch Database","Introduction to Stretch Database","microsoft azure sql server stretch database","SQL Server 2016 Stretch Database","sql server stretch database azure","sql server stretch database limitations","SQL Server stretch databases","sql stretch database azure","stretch database azure","stretch database feature in sql server","stretch database feature in sql server 2016","stretch database in sql server","stretch database in sql server 2016","stretch database in sql server 2016 step by step","stretch database limitations","Stretch Database Restrictions","stretch database sql","stretch database to minimize storage costs","stretch db in sql server","Understanding Stretch Database","What is azure stretch database?","what is sql server stretch database in azure","what is sql stretch database","what is stretch database in sql server 2016","What is stretch database in SQL Server?","What is stretch database?","What is the use case where we can use stretch database?"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/","name":"What is Stretch Database in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-3.png","datePublished":"2019-12-10T07:29:42+00:00","dateModified":"2019-12-10T07:29:45+00:00","description":"What is Stretch Database in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-3.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-3.png","width":558,"height":325},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/10\/what-is-stretch-database-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is Stretch Database in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14182"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14182\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14198"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}