{"id":12067,"date":"2019-05-07T21:48:49","date_gmt":"2019-05-07T21:48:49","guid":{"rendered":"https:\/\/dbtut.com\/?p=12067"},"modified":"2019-05-07T21:48:49","modified_gmt":"2019-05-07T21:48:49","slug":"how-to-attach-database-without-transaction-log-using-attach_rebuild_log","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/","title":{"rendered":"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG"},"content":{"rendered":"<p>It is possible to attach the database without a log file using ATTACH_REBUILD_LOG. With the help of the following script, we attach the ASPNETDB database when there is only mdf file.<\/p>\n<pre class=\"lang:default decode:true \">USE [master]\r\nGO\r\nCREATE DATABASE [ASPNETDB] ON ( FILENAME = N'C:\\D\\Backup\\Aspnetmdf\\aspnetdb.mdf' ) FOR ATTACH_REBUILD_LOG\r\nGO\r\n<\/pre>\n<p>Because there is not a log file, it creates a new log file as you see below.<\/p>\n<p id=\"VqDraGv\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-12068  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/img_5cd1fb293518d.png\" alt=\"\" width=\"750\" height=\"162\" \/><\/p>\n<p lang=\"en-US\">You can find the details of the detach and attach operations in the article titled &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/02\/how-to-change-the-disk-of-database-files-on-sql-serverdetach-attach-backup-restore-methods\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Change The Disk Of Database Files<\/a>&#8220;.<\/p>\n<p lang=\"en-US\">If you want to detach or attach database containing filestream data you may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/01\/how-to-detach-and-attach-a-database-containing-filestream-data\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Detach and Attach a Database Containing FileStream Data<\/a>&#8220;.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12067\" class=\"pvc_stats all  \" data-element-id=\"12067\" 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>It is possible to attach the database without a log file using ATTACH_REBUILD_LOG. With the help of the following script, we attach the ASPNETDB database when there is only mdf file. USE [master] GO CREATE DATABASE [ASPNETDB] ON ( FILENAME = N&#8217;C:\\D\\Backup\\Aspnetmdf\\aspnetdb.mdf&#8217; ) FOR ATTACH_REBUILD_LOG GO Because there is not a log file, it creates &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_12067\" class=\"pvc_stats all  \" data-element-id=\"12067\" 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":12071,"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":[3879,3866,3868,3877,3870,3869,3867,3874,3878,3876,3873,3871,3872,3875],"class_list":["post-12067","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-attach-sql-database-without-log","tag-attach_rebuild_log","tag-can-we-restore-database-from-mdf-file","tag-create-database-for-attach","tag-how-do-i-add-a-database-to-sql-server","tag-how-do-you-attach-a-database","tag-how-to-attach-database-without-transaction-log","tag-how-to-restore-sql-database-from-bak-file-without-log-file","tag-mssql-attach-database-without-log","tag-sql-server-attach-database-script","tag-sql-server-attach-database-without-log-file","tag-sql-server-restore-database-without-log-file","tag-the-log-cannot-be-rebuilt-because-there-were-open-transactions-users-when-the-database-was-shutdown","tag-the-log-cannot-be-rebuilt-when-the-primary-file-is-read-only"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-07T21:48:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-8.png\" \/>\n\t<meta property=\"og:image:width\" content=\"623\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"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\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG\",\"datePublished\":\"2019-05-07T21:48:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/\"},\"wordCount\":115,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-8.png\",\"keywords\":[\"attach sql database without log\",\"ATTACH_REBUILD_LOG\",\"Can we restore database from MDF file?\",\"create database for attach\",\"How do I add a database to SQL Server?\",\"How do you attach a database?\",\"How To Attach Database Without Transaction Log\",\"how to restore sql database from .bak file without log file\",\"mssql attach database without log\",\"sql server attach database script\",\"sql server attach database without log file\",\"sql server restore database without log file\",\"the log cannot be rebuilt because there were open transactions\/users when the database was shutdown\",\"the log cannot be rebuilt when the primary file is read-only\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/\",\"name\":\"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-8.png\",\"datePublished\":\"2019-05-07T21:48:49+00:00\",\"description\":\"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-8.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-8.png\",\"width\":623,\"height\":338},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG\"}]},{\"@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":"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG - Database Tutorials","description":"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/","og_locale":"en_US","og_type":"article","og_title":"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG - Database Tutorials","og_description":"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG","og_url":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/","og_site_name":"Database Tutorials","article_published_time":"2019-05-07T21:48:49+00:00","og_image":[{"width":623,"height":338,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-8.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG","datePublished":"2019-05-07T21:48:49+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/"},"wordCount":115,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-8.png","keywords":["attach sql database without log","ATTACH_REBUILD_LOG","Can we restore database from MDF file?","create database for attach","How do I add a database to SQL Server?","How do you attach a database?","How To Attach Database Without Transaction Log","how to restore sql database from .bak file without log file","mssql attach database without log","sql server attach database script","sql server attach database without log file","sql server restore database without log file","the log cannot be rebuilt because there were open transactions\/users when the database was shutdown","the log cannot be rebuilt when the primary file is read-only"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/","url":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/","name":"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-8.png","datePublished":"2019-05-07T21:48:49+00:00","description":"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-8.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-8.png","width":623,"height":338},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/07\/how-to-attach-database-without-transaction-log-using-attach_rebuild_log\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Attach Database Without Transaction Log Using ATTACH_REBUILD_LOG"}]},{"@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\/12067","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=12067"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12067\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12071"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}