{"id":2197,"date":"2022-11-02T07:00:00","date_gmt":"2022-11-02T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=2197"},"modified":"2023-11-20T20:28:52","modified_gmt":"2023-11-20T17:28:52","slug":"gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k-2\/","title":{"rendered":"A disk is full of SQL Server datafiles, what should I do?"},"content":{"rendered":"<p>Sometimes a disk will suddenly become full. On this disk we may have one base or many, while we may have space on another disk, we have to somehow find which one <strong>datafiles <\/strong>they are full. In this article we will see how we can quickly solve the problem <strong>SQL<\/strong> <strong>Server<\/strong>. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">We find how many datafiles with autogrowth have filled the disk<\/h2>\n\n\n\n<p>Our first move is to quickly find out which one <strong>datafiles <\/strong>who have <strong>autogrowth <\/strong>on the disk are full. In order to be able to check all bases in the instance at the same time, we should use the procedure <strong>sp_MSforeachdb<\/strong>.<\/p>\n\n\n\n<p>With the script I have written, we simply change the disk that has been filled in where <em><strong>s.physical_name like \u201dC:\\%\u201d<\/strong><\/em> and with the number for the percentage and above that we want it to bring us <strong><em>CAST(\u2026 as numeric ) &gt; 89<\/em><\/strong>:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">sp_MSforeachdb 'USE [?]\nSELECT\ndb_name(s.database_id) as DBName,\ns.name AS [Name],\ns.physical_name AS [FileName],\n(s.size * CONVERT(float,8))\/1024 AS [SizeMB],\n(CAST(CASE s.type WHEN 2 THEN 0 ELSE CAST(FILEPROPERTY(s.name, ''SpaceUsed'') AS float)* CONVERT(float,8) END AS float))\/1024 AS [UsedSpaceMB],\ncast(((CAST(CASE s.type WHEN 2 THEN 0 ELSE CAST(FILEPROPERTY(s.name, ''SpaceUsed'') AS float)* CONVERT(float,8) END AS float))\/1024) \/ ((s.size * CONVERT(float,8))\/1024) * 100 as numeric )as [Percentage]\nFROM\nsys.filegroups AS g\nINNER JOIN sys.master_files AS s ON ((s.type = 2 or s.type = 0) and s.database_id = db_id() and (s.drop_lsn IS NULL)) AND (s.data_space_id=g.data_space_id)\nwhere\ns.[type] = 0 and s.physical_name like ''C:\\%'' and s.growth != 0 \nand cast(((CAST(CASE s.type WHEN 2 THEN 0 ELSE CAST(FILEPROPERTY(s.name, ''SpaceUsed'') AS float)* CONVERT(float,8) END AS float))\/1024) \/ ((s.size * CONVERT(float,8))\/1024) * 100 as numeric ) > 89\n'<\/pre>\n\n\n\n<p>We quickly see that we have two datafiles on disk <em>C:\/<\/em> which have an occupancy rate above 90%. We can export the results directly to <strong>csv <\/strong>file without headers so that if there are too many we can have them all <strong>physical names <\/strong>in one column for the next step:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"658\" height=\"219\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/dfw-01.png\" alt=\"\" class=\"wp-image-2198\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/dfw-01.png 658w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/dfw-01-300x100.png 300w\" sizes=\"auto, (max-width: 658px) 100vw, 658px\" \/><figcaption class=\"wp-element-caption\">01<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">We create new datafiles for what was filled on the other disk<\/h2>\n\n\n\n<p>As a next step we want to give new datafiles to another disk for what we found in the previous step to be full. In the next script that I have made, we define the parameter <strong><em>@new_storage=&#039;D:\\Data\\&#039;<\/em><\/strong> for the disk that will also go to the parameter <strong><em>sys.master_files.physical_name in<br>(&#039;C:\\Program\u2026..,&#039;C:\\\u2026.&#039;)<\/em><\/strong> as many datafiles as we found in the previous step:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">declare @new_storage varchar(50)\nset @new_storage='D:\\Data\\'\n\nselect \n    'ALTER DATABASE [' + sys.databases.name + '] ADD FILE ( NAME = ' + sys.master_files.name + '_new, FILENAME = '+@new_storage+ sys.master_files.name + '_new.ndf'',SIZE = 1GB, FILEGROWTH = 256MB);'\nfrom sys.master_files \ncross apply sys.databases\ncross apply sys.dm_db_file_space_usage \nWhere \nsys.databases.database_id = sys.master_files.database_id and \nsys.dm_db_file_space_usage .file_id = master_files.file_id and\nsys.master_files.[type] = 0 and \n--sys.master_files.physical_name like 'C:\\%' and \nsys.master_files.growth != 0 and \nsys.master_files.physical_name in  --gia perisotero elegxo\n(\n'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQL19\\MSSQL\\DATA\\master.mdf',\n'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQL19\\MSSQL\\DATA\\MSDBData.mdf'\n)<\/pre>\n\n\n\n<p>Then we simply execute the generated commands. For the example I have set an initial size of 1gb with 256mb autogrowth:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"776\" height=\"123\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/dfw-02.png\" alt=\"\" class=\"wp-image-2199\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/dfw-02.png 776w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/dfw-02-300x48.png 300w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/dfw-02-768x122.png 768w\" sizes=\"auto, (max-width: 776px) 100vw, 776px\" \/><figcaption class=\"wp-element-caption\">02<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">We have one more thing left, autogrowth is still open<\/h2>\n\n\n\n<p>After we solved the problem and now the bases are writing to another disc, it is good to close the autogrowth on them since the original disc has no space. All we have to do is have in the parameter <em><strong>physical_name like &#039;C:\\%&#039;<\/strong><\/em> the analog drive:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">select \n    'ALTER DATABASE [' + db_name(database_id) + '] MODIFY FILE ( NAME = N''' + name + ''', FILEGROWTH = 0)'\nfrom sys.master_files Where [type] = 0 and \nphysical_name like 'C:\\%' and \ngrowth != 0 \n--and sys.master_files.physical_name in  -- gia perisotero elegxo\n--(\n--'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQL19\\MSSQL\\DATA\\master.mdf',\n--'C:\\Program Files\\Microsoft SQL Server\\MSSQL15.SQL19\\MSSQL\\DATA\\MSDBData.mdf'\n--)<\/pre>\n\n\n\n<p>And finally we simply execute the commands created to close autogrowth on the files of this disk:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"139\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/dfw-03.png\" alt=\"\" class=\"wp-image-2200\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/dfw-03.png 435w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/10\/dfw-03-300x96.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><figcaption class=\"wp-element-caption\">03<\/figcaption><\/figure>","protected":false},"excerpt":{"rendered":"<p>Sometimes a disk will suddenly become full. On this disk we may have one base or many, while we may have space on another disk, we must somehow find which datafiles are full. In this article we will see how quickly we can provide a solution to SQL Server. We find as many datafiles [\u2026]<\/p>","protected":false},"author":1,"featured_media":702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,15],"tags":[29,23,30,6],"class_list":["post-2197","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-ms-sqlserver","tag-databases","tag-microsoft","tag-rdbms","tag-sqlserver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u0393\u03ad\u03bc\u03b9\u03c3\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2 \u03bc\u03b5 \u03c4\u03b1 datafiles \u03c4\u03bf\u03c5 SQL Server, \u03c4\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03c9; - DataPlatform.gr<\/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.dataplatform.gr\/en\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0393\u03ad\u03bc\u03b9\u03c3\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2 \u03bc\u03b5 \u03c4\u03b1 datafiles \u03c4\u03bf\u03c5 SQL Server, \u03c4\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03c9; - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u039a\u03ac\u03c0\u03bf\u03b9\u03b5\u03c2 \u03c6\u03bf\u03c1\u03ad\u03c2 \u03b8\u03b1 \u03c4\u03cd\u03c7\u03b5\u03b9 \u03be\u03b1\u03c6\u03bd\u03b9\u03ba\u03ac \u03bd\u03b1 \u03b3\u03b5\u03bc\u03af\u03c3\u03b5\u03b9 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2. \u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc\u03bd \u03c4\u03bf\u03bd \u03b4\u03af\u03c3\u03ba\u03bf \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03ba\u03b1\u03b9 \u03c0\u03bf\u03bb\u03bb\u03ad\u03c2, \u03b5\u03bd\u03ce \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03c7\u03ce\u03c1\u03bf \u03c3\u03b5 \u03ac\u03bb\u03bb\u03bf \u03b4\u03af\u03c3\u03ba\u03bf \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03ba\u03ac\u03c0\u03c9\u03c2 \u03bd\u03b1 \u03b2\u03c1\u03bf\u03cd\u03bc\u03b5 \u03c0\u03bf\u03b9\u03b1 datafiles \u03ad\u03c7\u03bf\u03c5\u03bd \u03b3\u03b5\u03bc\u03af\u03c3\u03b5\u03b9. \u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c0\u03c9\u03c2 \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03b4\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03bb\u03cd\u03c3\u03b7 \u03c3\u03c4\u03bf\u03bd SQL Server. \u0392\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03cc\u03c3\u03b1 datafiles [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k-2\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-02T04:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-20T17:28:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u0393\u03ad\u03bc\u03b9\u03c3\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2 \u03bc\u03b5 \u03c4\u03b1 datafiles \u03c4\u03bf\u03c5 SQL Server, \u03c4\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03c9;\",\"datePublished\":\"2022-11-02T04:00:00+00:00\",\"dateModified\":\"2023-11-20T17:28:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/\"},\"wordCount\":59,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"keywords\":[\"Databases\",\"Microsoft\",\"RDBMS\",\"SQL Server\"],\"articleSection\":[\"Databases\",\"Microsoft SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/\",\"name\":\"\u0393\u03ad\u03bc\u03b9\u03c3\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2 \u03bc\u03b5 \u03c4\u03b1 datafiles \u03c4\u03bf\u03c5 SQL Server, \u03c4\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03c9; - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"datePublished\":\"2022-11-02T04:00:00+00:00\",\"dateModified\":\"2023-11-20T17:28:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft SQL Server\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/ms-sqlserver\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u0393\u03ad\u03bc\u03b9\u03c3\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2 \u03bc\u03b5 \u03c4\u03b1 datafiles \u03c4\u03bf\u03c5 SQL Server, \u03c4\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03c9;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u0393\u03ad\u03bc\u03b9\u03c3\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2 \u03bc\u03b5 \u03c4\u03b1 datafiles \u03c4\u03bf\u03c5 SQL Server, \u03c4\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03c9; - DataPlatform.gr","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.dataplatform.gr\/en\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k-2\/","og_locale":"en_US","og_type":"article","og_title":"\u0393\u03ad\u03bc\u03b9\u03c3\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2 \u03bc\u03b5 \u03c4\u03b1 datafiles \u03c4\u03bf\u03c5 SQL Server, \u03c4\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03c9; - DataPlatform.gr","og_description":"\u039a\u03ac\u03c0\u03bf\u03b9\u03b5\u03c2 \u03c6\u03bf\u03c1\u03ad\u03c2 \u03b8\u03b1 \u03c4\u03cd\u03c7\u03b5\u03b9 \u03be\u03b1\u03c6\u03bd\u03b9\u03ba\u03ac \u03bd\u03b1 \u03b3\u03b5\u03bc\u03af\u03c3\u03b5\u03b9 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2. \u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc\u03bd \u03c4\u03bf\u03bd \u03b4\u03af\u03c3\u03ba\u03bf \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03ba\u03b1\u03b9 \u03c0\u03bf\u03bb\u03bb\u03ad\u03c2, \u03b5\u03bd\u03ce \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03ad\u03c7\u03bf\u03c5\u03bc\u03b5 \u03c7\u03ce\u03c1\u03bf \u03c3\u03b5 \u03ac\u03bb\u03bb\u03bf \u03b4\u03af\u03c3\u03ba\u03bf \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03ba\u03ac\u03c0\u03c9\u03c2 \u03bd\u03b1 \u03b2\u03c1\u03bf\u03cd\u03bc\u03b5 \u03c0\u03bf\u03b9\u03b1 datafiles \u03ad\u03c7\u03bf\u03c5\u03bd \u03b3\u03b5\u03bc\u03af\u03c3\u03b5\u03b9. \u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c0\u03c9\u03c2 \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03b1 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03b4\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03bb\u03cd\u03c3\u03b7 \u03c3\u03c4\u03bf\u03bd SQL Server. \u0392\u03c1\u03af\u03c3\u03ba\u03bf\u03c5\u03bc\u03b5 \u03cc\u03c3\u03b1 datafiles [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k-2\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2022-11-02T04:00:00+00:00","article_modified_time":"2023-11-20T17:28:52+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u0393\u03ad\u03bc\u03b9\u03c3\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2 \u03bc\u03b5 \u03c4\u03b1 datafiles \u03c4\u03bf\u03c5 SQL Server, \u03c4\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03c9;","datePublished":"2022-11-02T04:00:00+00:00","dateModified":"2023-11-20T17:28:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/"},"wordCount":59,"commentCount":2,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","keywords":["Databases","Microsoft","RDBMS","SQL Server"],"articleSection":["Databases","Microsoft SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/","url":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/","name":"\u0393\u03ad\u03bc\u03b9\u03c3\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2 \u03bc\u03b5 \u03c4\u03b1 datafiles \u03c4\u03bf\u03c5 SQL Server, \u03c4\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03c9; - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","datePublished":"2022-11-02T04:00:00+00:00","dateModified":"2023-11-20T17:28:52+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/gemise-enas-diskos-me-ta-datafiles-toy-sql-server-ti-na-k\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Server","item":"https:\/\/www.dataplatform.gr\/category\/databases\/ms-sqlserver\/"},{"@type":"ListItem","position":4,"name":"\u0393\u03ad\u03bc\u03b9\u03c3\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b4\u03af\u03c3\u03ba\u03bf\u03c2 \u03bc\u03b5 \u03c4\u03b1 datafiles \u03c4\u03bf\u03c5 SQL Server, \u03c4\u03b9 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03c9;"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=2197"}],"version-history":[{"count":1,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2197\/revisions"}],"predecessor-version":[{"id":5622,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2197\/revisions\/5622"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/702"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=2197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=2197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=2197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}