{"id":6549,"date":"2018-12-13T15:16:02","date_gmt":"2018-12-13T15:16:02","guid":{"rendered":"https:\/\/dbtut.com\/?p=6549"},"modified":"2018-12-21T13:11:50","modified_gmt":"2018-12-21T13:11:50","slug":"create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/","title":{"rendered":"CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file &#8221; because it already exists. )"},"content":{"rendered":"<p>&nbsp;<\/p>\n<h3>ERROR MESAGGE:<\/h3>\n<p>CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file &#8216;C:\\Program Files\\Microsoft SQL Server\\MSSQL.x\\MSSQL\\DATA\\&lt;file_name&gt;&#8217; because it already exists. Change the file path or the file name, and retry the operation. (Microsoft SQL Server, Error: 1802)&#8221;&lt;\/file_name&gt;<\/p>\n<h3>EXPLANATION:<\/h3>\n<p>You may experience this error when creating a database.<\/p>\n<p><strong>Consider the following scenario:<\/strong><\/p>\n<p>You have a database named &#8220;xxx&#8221;. By default, if you don&#8217;t specifically specify it, the data file name of this database is &#8220;xxx.mdf&#8221; and the name of the log file is &#8220;xxx_log.ldf&#8221;.<\/p>\n<p>You want to create one more from the database named &#8220;xxx&#8221;, but you want to keep the one already created.<\/p>\n<p>For this, you are changing the name of the old &#8220;xxx&#8221; database to &#8220;xxx_old&#8221;. But in this case, only the logical name of the database has changed. So the file names remain the same.<\/p>\n<p>The name of the database that you are trying to create is &#8220;xxx&#8221;, so the file names are identical to the file names of the previously created &#8220;xxx&#8221; database, so you get errors.<\/p>\n<h3>SOLUTION:<\/h3>\n<p>If you are trying to create your database using SQL Server Management Studio, you can resolve this issue by specifying the file names yourself as you see below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png\" width=\"655\" height=\"234\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>If you are creating your database with the CREATE DATABASE command, you can specify the file name as you see in the sample script below.<\/p>\n<pre class=\"lang:default decode:true \">CREATE DATABASE [xxx] ON PRIMARY\u00a0\r\n(NAME = N'xxx_new', FILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL.x\\MSSQL\\DATA\\xxx_new.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB )\u00a0\r\nLOG ON\u00a0\r\n( NAME = N'xxx_log_new', FILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL.x\\MSSQL\\DATA\\xxx_log_new.ldf' , SIZE = 1024KB , FILEGROWTH = 10%)<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6549\" class=\"pvc_stats all  \" data-element-id=\"6549\" 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; ERROR MESAGGE: CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file &#8216;C:\\Program Files\\Microsoft SQL Server\\MSSQL.x\\MSSQL\\DATA\\&lt;file_name&gt;&#8217; because it already exists. Change the file path or the file name, and retry the operation. (Microsoft SQL Server, Error: 1802)&#8221;&lt;\/file_name&gt; EXPLANATION: You may experience this error when creating a database. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_6549\" class=\"pvc_stats all  \" data-element-id=\"6549\" 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":423,"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-6549","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file &#039;&#039; because it already exists. ) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file &#039;C:Program FilesMicrosoft SQL ServerMSSQL.xMSSQLDATA&#039; because it already exists. Change the file path or the file name, and retry the operation. (Microsoft SQL Server, Error: 1802)&quot;\" \/>\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\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file &#039;&#039; because it already exists. ) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file &#039;C:Program FilesMicrosoft SQL ServerMSSQL.xMSSQLDATA&#039; because it already exists. Change the file path or the file name, and retry the operation. (Microsoft SQL Server, Error: 1802)&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-13T15:16:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-21T13:11:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png\" \/>\n<meta name=\"author\" content=\"Ekrem \u00d6nsoy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ekrem \u00d6nsoy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 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\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file &#8221; because it already exists. )\",\"datePublished\":\"2018-12-13T15:16:02+00:00\",\"dateModified\":\"2018-12-21T13:11:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/\"},\"wordCount\":273,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/\",\"name\":\"CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file '' because it already exists. ) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png\",\"datePublished\":\"2018-12-13T15:16:02+00:00\",\"dateModified\":\"2018-12-21T13:11:50+00:00\",\"description\":\"CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file 'C:\\\\Program Files\\\\Microsoft SQL Server\\\\MSSQL.x\\\\MSSQL\\\\DATA\\\\' because it already exists. Change the file path or the file name, and retry the operation. (Microsoft SQL Server, Error: 1802)\\\"\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png\",\"width\":910,\"height\":325},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file &#8221; because it already exists. )\"}]},{\"@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\/42a3e874ed0bf8053fa123a3a1f6ee46\",\"name\":\"Ekrem \u00d6nsoy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"caption\":\"Ekrem \u00d6nsoy\"},\"description\":\"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.\",\"url\":\"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file '' because it already exists. ) - Database Tutorials","description":"CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file 'C:Program FilesMicrosoft SQL ServerMSSQL.xMSSQLDATA' because it already exists. Change the file path or the file name, and retry the operation. (Microsoft SQL Server, Error: 1802)\"","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\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/","og_locale":"en_US","og_type":"article","og_title":"CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file '' because it already exists. ) - Database Tutorials","og_description":"CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file 'C:Program FilesMicrosoft SQL ServerMSSQL.xMSSQLDATA' because it already exists. Change the file path or the file name, and retry the operation. (Microsoft SQL Server, Error: 1802)\"","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-13T15:16:02+00:00","article_modified_time":"2018-12-21T13:11:50+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png","type":"","width":"","height":""}],"author":"Ekrem \u00d6nsoy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ekrem \u00d6nsoy","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file &#8221; because it already exists. )","datePublished":"2018-12-13T15:16:02+00:00","dateModified":"2018-12-21T13:11:50+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/"},"wordCount":273,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/","name":"CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file '' because it already exists. ) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png","datePublished":"2018-12-13T15:16:02+00:00","dateModified":"2018-12-21T13:11:50+00:00","description":"CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.x\\MSSQL\\DATA\\' because it already exists. Change the file path or the file name, and retry the operation. (Microsoft SQL Server, Error: 1802)\"","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/12\/190.png","width":910,"height":325},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/13\/create-database-failed-some-file-names-listed-could-not-be-created-cannot-create-file-because-it-already-exists\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file &#8221; because it already exists. )"}]},{"@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\/42a3e874ed0bf8053fa123a3a1f6ee46","name":"Ekrem \u00d6nsoy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","caption":"Ekrem \u00d6nsoy"},"description":"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.","url":"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6549","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\/423"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=6549"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6549\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}