{"id":4603,"date":"2018-11-03T12:20:07","date_gmt":"2018-11-03T12:20:07","guid":{"rendered":"https:\/\/dbtut.com\/?p=4603"},"modified":"2018-11-28T07:54:58","modified_gmt":"2018-11-28T07:54:58","slug":"instant-file-initializationrestore-or-allocate-disk-space-faster","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/","title":{"rendered":"Instant File Initialization(Restore or Allocate Disk Space Faster)"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Instant File Initialization is a feature that introduced with SQL Server 2005 and Windows Server 2003-Windows XP. To enable this feature, the SQL Server service account must be granted the necessary rights on Windows. When this feature is activated, operations on the data files of SQL Server can be performed more quickly.<\/p>\n<p>When any of the following operations occurs on SQL Server, SQL Server requests to allocate files from Windows;<\/p>\n<p><strong>1. Creating a database,<\/strong><\/p>\n<p><strong>2. Adding data files to an existing database,<\/strong><\/p>\n<p><strong>3. Increasing the data file size of an existing database or performing this operation with autogrowth,<\/strong><\/p>\n<p><strong>4. Restore a database that does not exist<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>These spaces requested by SQL Server are filled with 0(zero) and then allocated to the sql server.<\/p>\n<p>Of course, it takes some time to fill them with 0(zero) when the requested spaces are large.<\/p>\n<p>If SQL Server Service account is granted on perform volume maintenance tasks on Windows, then windows give this space to SQL Server without filling with 0(zero).<\/p>\n<p>The process will be accelerated as there is no need to fill these spaces with 0(zero).<\/p>\n<p>Now let&#8217;s test the effect when we activate Instant File Initialization.<\/p>\n<p>First, we will perform the operations without authorization and record the completion times. In the second stage, we will perform authorization and check the completion time of the operations.<\/p>\n<p>CPU for the server that I run the tests: Intel Xeon X5670, 2.93GHz,2933Mhz, 8 Core(s)<\/p>\n<p>&nbsp;<\/p>\n<h3>1) Create Database:<\/h3>\n<p>In my test environment, it took 5 minutes and 18 seconds to create a new database with a size of 100 GB when Instant File Initialization was not active with the following command. Of course, this time may increase or decrease according to the power of your server.<\/p>\n<pre class=\"lang:default decode:true\">CREATE DATABASE [CreateDatabase100GB]\r\nCONTAINMENT = NONE\r\nON PRIMARY\r\n( NAME = N'CreateDatabase100GB', FILENAME = N'H:\\CreateDatabase100GB.mdf' , SIZE = 104857600KB , FILEGROWTH = 1048576KB )\r\nLOG ON\r\n( NAME = N'CreateDatabase100GB_log', FILENAME = N'H:\\CreateDatabase100GB_log.ldf' , SIZE = 262144KB , FILEGROWTH = 262144KB )\r\nGO<\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After activating Instant File Initialization, the same process took 3 seconds as shown below.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/518-2.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>2) Adding data files to an existing database:<\/h3>\n<p>Let&#8217;s add a data file to a database with a size of 20gb.<\/p>\n<p>When Instant File Initialization was inactive, it took 1 minute and 1 second to perform this operation.<\/p>\n<pre class=\"lang:default decode:true \">USE [master]\r\nGO\r\nALTER DATABASE [CreateDatabase100GB] ADD FILE ( NAME = N'CreateDatabase100GB_2',\r\nFILENAME = N'H:\\CreateDatabase100GB_2.ndf' , SIZE = 20971520KB , FILEGROWTH = 1048576KB )\r\nTO FILEGROUP [PRIMARY]\r\nGO<\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/889-1.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After activating Instant File Initialization, the same process was completed in less than 1 second as shown below.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/788.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>3) Increasing the data file size of an existing database or performing this operation with autogrowth:<\/h3>\n<p>When Instant File Initialization was inactive, it took 1 minute and 42 seconds to increase the size of the file we added.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/597-1.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After activating Instant File Initialization, the same process was completed in less than 1 second as shown below.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/705.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>The size of the database we&#8217;ve created has reached 150 GB. Now let&#8217;s take a backup of this database and delete it. When we restored this backup when Instant File Initialization was inactive, it took 12 minutes and 1 second.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/139.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After activating Instant File Initialization, the same process took 3 seconds as shown below.<\/p>\n<p>&nbsp;<\/p>\n<h3>Authorize SQL Server Service Account on Perform Volume Maintenance Tasks:<\/h3>\n<p>We are writing gpedit.msc as shown below on search.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/896-1.png\" width=\"347\" height=\"241\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>From the Local Group Policy Editor, select User Rights Assingment like below. Then right click on Perform Volume Maintenance Tasks to select properties.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/11\/569.png\" width=\"672\" height=\"648\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Click &#8220;add user or group&#8221; and add the sql server service account. This process is completed when you restart the SQL Server service account.<\/p>\n<p>&nbsp;<\/p>\n<h3>Security Risks for enabling Instant File Initialization:<\/h3>\n<p>When the data saved on this space allocated to sql server is deleted, it is returned to windows again without writing 0(zero). And if there is no encryption on the data, an authorized person on the server can read this field returned by SQL Server.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_4603\" class=\"pvc_stats all  \" data-element-id=\"4603\" 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>&nbsp; Instant File Initialization is a feature that introduced with SQL Server 2005 and Windows Server 2003-Windows XP. To enable this feature, the SQL Server service account must be granted the necessary rights on Windows. When this feature is activated, operations on the data files of SQL Server can be performed more quickly. When any &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_4603\" class=\"pvc_stats all  \" data-element-id=\"4603\" 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":0,"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":[],"class_list":["post-4603","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":307,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Instant File Initialization(Restore or Allocate Disk Space Faster) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Instant File Initialization(Restore or Allocate Disk Space Faster)\" \/>\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\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Instant File Initialization(Restore or Allocate Disk Space Faster) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Instant File Initialization(Restore or Allocate Disk Space Faster)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-03T12:20:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-28T07:54:58+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Instant File Initialization(Restore or Allocate Disk Space Faster)\",\"datePublished\":\"2018-11-03T12:20:07+00:00\",\"dateModified\":\"2018-11-28T07:54:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/\"},\"wordCount\":592,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/\",\"name\":\"Instant File Initialization(Restore or Allocate Disk Space Faster) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.png\",\"datePublished\":\"2018-11-03T12:20:07+00:00\",\"dateModified\":\"2018-11-28T07:54:58+00:00\",\"description\":\"Instant File Initialization(Restore or Allocate Disk Space Faster)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#primaryimage\",\"url\":\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.png\",\"contentUrl\":\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Instant File Initialization(Restore or Allocate Disk Space Faster)\"}]},{\"@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":"Instant File Initialization(Restore or Allocate Disk Space Faster) - Database Tutorials","description":"Instant File Initialization(Restore or Allocate Disk Space Faster)","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\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/","og_locale":"en_US","og_type":"article","og_title":"Instant File Initialization(Restore or Allocate Disk Space Faster) - Database Tutorials","og_description":"Instant File Initialization(Restore or Allocate Disk Space Faster)","og_url":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/","og_site_name":"Database Tutorials","article_published_time":"2018-11-03T12:20:07+00:00","article_modified_time":"2018-11-28T07:54:58+00:00","og_image":[{"url":"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Instant File Initialization(Restore or Allocate Disk Space Faster)","datePublished":"2018-11-03T12:20:07+00:00","dateModified":"2018-11-28T07:54:58+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/"},"wordCount":592,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#primaryimage"},"thumbnailUrl":"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/","url":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/","name":"Instant File Initialization(Restore or Allocate Disk Space Faster) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#primaryimage"},"thumbnailUrl":"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.png","datePublished":"2018-11-03T12:20:07+00:00","dateModified":"2018-11-28T07:54:58+00:00","description":"Instant File Initialization(Restore or Allocate Disk Space Faster)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#primaryimage","url":"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.png","contentUrl":"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2016\/09\/355-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/11\/03\/instant-file-initializationrestore-or-allocate-disk-space-faster\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Instant File Initialization(Restore or Allocate Disk Space Faster)"}]},{"@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\/4603","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=4603"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/4603\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=4603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=4603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=4603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}