“One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.”<\/p>\n
If the Data files and Transaction Log files belong to different backups or if they belong to different databases, an error message can be received.<\/p>\n
For example, imagine you have a database named “x”. Consider that the backup is taken directly as * .mdf \\ ndf and * .ldf.<\/p>\n
If you combine data files from 30.09.2009 and Transaction Log files dated 01.10.2009, you will see this error message if you try to attach the database in this way.<\/p>\n
You must match the correct Data and Transaction Log files and attach them.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"excerpt":{"rendered":"
ERROR MESAGGE: “One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.” EXPLANATION: If the Data files and …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> <\/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-6647","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"\n
One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. - Database Tutorials<\/title>\n<meta name=\"description\" content=\"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.\" \/>\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\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-16T17:46:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-21T13:02:25+00:00\" \/>\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=\"1 minute\" \/>\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\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.\",\"datePublished\":\"2018-12-16T17:46:09+00:00\",\"dateModified\":\"2018-12-21T13:02:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/\"},\"wordCount\":168,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/\",\"name\":\"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-12-16T17:46:09+00:00\",\"dateModified\":\"2018-12-21T13:02:25+00:00\",\"description\":\"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.\"}]},{\"@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":"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. - Database Tutorials","description":"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.","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\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/","og_locale":"en_US","og_type":"article","og_title":"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. - Database Tutorials","og_description":"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.","og_url":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/","og_site_name":"Database Tutorials","article_published_time":"2018-12-16T17:46:09+00:00","article_modified_time":"2018-12-21T13:02:25+00:00","author":"Ekrem \u00d6nsoy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ekrem \u00d6nsoy","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.","datePublished":"2018-12-16T17:46:09+00:00","dateModified":"2018-12-21T13:02:25+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/"},"wordCount":168,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/","url":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/","name":"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-12-16T17:46:09+00:00","dateModified":"2018-12-21T13:02:25+00:00","description":"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/12\/16\/one-or-more-files-do-not-match-the-primary-file-of-the-database-if-you-are-attempting-to-attach-a-database-retry-the-operation-with-the-correct-files\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files."}]},{"@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\/6647","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=6647"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/6647\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=6647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=6647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=6647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}