{"id":41052,"date":"2019-06-04T06:57:49","date_gmt":"2019-06-04T06:57:49","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=41052"},"modified":"2025-10-25T08:49:08","modified_gmt":"2025-10-25T08:49:08","slug":"fr-rattacher-une-base-de-donnees-sql-sans-ldf","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/","title":{"rendered":"3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>Les fichiers de base de donn&eacute;es ma&icirc;tre <strong>(MDF)<\/strong> et les fichiers log de transactions <strong>(LDF)<\/strong> sont deux fichiers principaux utilis&eacute;s par SQL Server pour enregistrer le contenu de la base de donn&eacute;es. Si une base de donn&eacute;es semble anormale ou devient corrompue, vous pouvez v&eacute;rifier les journaux des transactions pour d&eacute;terminer la cause de l&rsquo;erreur.<\/p><p>En raison de la corruption dans la base de donn&eacute;es\nSQL, vous verrez le fichier journal des transactions appara&icirc;tre comme manquant,\net vous serez laiss&eacute; avec le fichier de base de donn&eacute;es ma&icirc;tre seulement.<\/p><p><strong>Remarque:<\/strong> Conform&eacute;ment aux directives Microsoft, vous ne pouvez pas restaurer la sauvegarde de la base de donn&eacute;es &agrave; partir de la version sup&eacute;rieure du serveur SQL Server vers sa version inf&eacute;rieure car en utilisant la strat&eacute;gie de sauvegarde et de restauration des bases de donn&eacute;es, la mise &agrave; niveau inf&eacute;rieure n&rsquo;est pas prise en charge.<\/p><p>Il est important de savoir qu&rsquo;un d&eacute;classement (downgrade) d&rsquo;une base de donn&eacute;es d&rsquo;une version sup&eacute;rieure du serveur SQL Server vers une version inf&eacute;rieure ne peut pas &ecirc;tre r&eacute;alis&eacute; en utilisant la technique &laquo;&nbsp;Sauvegarde &amp; restauration de base de donn&eacute;es&nbsp;&raquo; ou en suivant la m&eacute;thode <strong>&laquo;&nbsp;D&eacute;tachement et rattachement de base de donn&eacute;es&nbsp;&raquo;<\/strong>. Le d&eacute;classement d&rsquo;une base de donn&eacute;es vers sa version inf&eacute;rieure ne peut se faire qu&rsquo;en utilisant les services d&rsquo;int&eacute;gration SQL.<\/p><h2 class=\"wp-block-heading\" id=\"m&eacute;thodes-pour-rattacher-une-base-de-donn&eacute;es-microsoft-sql-server-sans-fichier-log\"><strong>M&eacute;thodes pour rattacher une base de donn&eacute;es Microsoft SQL Server sans fichier log<\/strong><\/h2><p>Il existe plusieurs fa&ccedil;ons de rattacher une base de\ndonn&eacute;es Microsoft SQL sans utiliser le log des transactions :<\/p><ul class=\"wp-block-list\">\n<li>En utilisant<strong> SQL Server Management Studio<\/strong>&nbsp;dans le serveur SQL <\/li>\n\n\n\n<li>En utilisant le script T-SQL <\/li>\n\n\n\n<li>En utilisant le logiciel Stellar Repair for MS SQL <\/li>\n<\/ul><p><strong>Autorisations requises :<\/strong> Pour rattacher la base de donn&eacute;es dans SQL Server, vous devez &ecirc;tre membre de db_owner.<\/p><h3 class=\"wp-block-heading\"><strong>M&eacute;thode #1: Utilisation de SQL Server Management Studio (SSMS)<\/strong><\/h3><p>Ici, il est important de mentionner que les &eacute;tapes donn&eacute;es ne fonctionneront que si la base de donn&eacute;es a &eacute;t&eacute; arr&ecirc;t&eacute;e proprement et que le fichier MDF est disponible.<\/p><ol class=\"wp-block-list\">\n<li>Effectuez un clic droit sur le n&oelig;ud de la <strong>Database <\/strong>dans la fen&ecirc;tre <strong>Object Explorer<\/strong>, puis cliquez sur <strong>Attach<\/strong>.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/10\/Click-to-attach.png\" alt=\"Stellar\"><figcaption class=\"wp-element-caption\"> <strong>Option de rattachement<\/strong> <\/figcaption><\/figure>\n<\/div><ol start=\"2\">\n<li>Dans la bo&icirc;te de dialogue <strong>Attach Databases<\/strong>, cliquez sur le bouton <strong>Add<\/strong>.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/10\/Click-on-Add.png\" alt=\"Stellar\"><figcaption class=\"wp-element-caption\"><strong>Ajouter une base de donn&eacute;es<\/strong><\/figcaption><\/figure>\n<\/div><ol start=\"3\">\n<li>La bo&icirc;te de dialogue <strong>Locate Database Files<\/strong> appara&icirc;tra, parcourez le chemin d&rsquo;acc&egrave;s o&ugrave; se trouve le fichier de base de donn&eacute;es MDF, cliquez sur le fichier &agrave; s&eacute;lectionner, puis cliquez sur <strong>OK<\/strong> pour quitter. Un nouveau fichier LDF sera cr&eacute;&eacute; par le serveur SQL en rattachant la base de donn&eacute;es SQL. La base de donn&eacute;es appara&icirc;tra d&eacute;sormais dans <strong>Databases.<\/strong><\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/10\/Location-of-MDF-file.png\" alt=\"Stellar\"><figcaption class=\"wp-element-caption\"><strong>S&eacute;lectionner le fichier MDF<\/strong><\/figcaption><\/figure>\n<\/div><ol start=\"4\">\n<li>Revenez maintenant &agrave; la bo&icirc;te de dialogue <strong>Attach Database<\/strong>. Sous <strong>database details<\/strong>, vous remarquerez que le serveur SQL est incapable de trouver le fichier LDF.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2016\/10\/Log-file-not-found.png\" alt=\"Stellar\"><figcaption class=\"wp-element-caption\"><strong>Supprimer l&rsquo;option Fichier journal<\/strong><\/figcaption><\/figure>\n<\/div><ol start=\"5\">\n<li>Pour joindre un fichier MDF sans fichier LDF, s&eacute;lectionnez le fichier journal des transactions, puis cliquez sur le bouton <strong>Remove<\/strong>.<\/li>\n<\/ol><h3><strong>M&eacute;thode #2: Utilisation de Transact-SQL<\/strong><\/h3><p>Vous pouvez rattacher la base de donn&eacute;es &agrave; SQL Server en utilisant <strong>T-SQL<\/strong> lorsque le journal des transactions est manquant. Cette proc&eacute;dure peut &ecirc;tre accomplie en utilisant un script d&eacute;fini dans lequel vous devez mentionner le nom de la base de donn&eacute;es. Le processus d&rsquo;ex&eacute;cution T-SQL garantit une instance de rattachement r&eacute;ussie dans la base de donn&eacute;es du serveur SQL. Le processus est d&eacute;crit ci-dessous :<\/p><pre>CREATE DATABASE testdb ON\n(FILENAME = &lsquo;C:\\Program Files\\Microsoft SQL Server\\..\\MSSQL\\DATA\\testdb.mdf&rsquo;)\nFor ATTACH_REBUILD_LOG\nGO\n<\/pre><p><strong>Remarque :<\/strong> testdb.mdf est le nom de mon fichier de base de\ndonn&eacute;es. Vous devez s&eacute;lectionner votre fichier.<\/p><p><strong>Ex&eacute;cutez DBCC CHECKDB<\/strong><\/p><p>Lorsque le fichier MDF est rattach&eacute; avec succ&egrave;s au serveur SQL avec le fichier journal des transactions manquant (LDF), vous devez ex&eacute;cuter <strong><a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/t-sql\/database-console-commands\/dbcc-checkdb-transact-sql?view=sql-server-2017\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"DBCC CHECKDB (opens in a new tab)\">DBCC CHECKDB<\/a> <\/strong>pour un contr&ocirc;le de coh&eacute;rence, c&rsquo;est-&agrave;-dire pour v&eacute;rifier l&rsquo;int&eacute;grit&eacute; logique et physique ou les erreurs dans tous les composants de la base de donn&eacute;es.<\/p><p>De m&ecirc;me, le processus de connexion de la base de donn&eacute;es sans journal des transactions &agrave; l&rsquo;aide de SQL Server Management Studio ne fonctionne que si la base de donn&eacute;es est proprement arr&ecirc;t&eacute;e et qu&rsquo;un MDF sain existe.<\/p><h3 class=\"wp-block-heading\"><strong>M&eacute;thode #3: Utilisation de Stellar Repair for MS SQL<\/strong><\/h3><p>Comme les deux proc&eacute;dures mentionn&eacute;es ci-dessus ne\nfonctionnent que si le fichier de base de donn&eacute;es ma&icirc;tre est dans un &eacute;tat sain,\nil est essentiel de r&eacute;parer le fichier\nMDF&nbsp; en cas\nd&rsquo;erreur. Cependant, un journal manquant ne peut pas affecter la base de donn&eacute;es\ndans une large mesure, mais si le MDF devient corrompu, vous ne serez pas en\nmesure de rattacher la base de donn&eacute;es.<\/p><p><strong><a href=\"https:\/\/www.stellarinfo.com\/fr\/recuperation-sql-base-de-donnes.php?utm_source=Site_Blog&amp;utm_medium=Site_Blog&amp;utm_campaign=Site_Blog_attach_database_without_log\">Stellar SQL Recovery Software<\/a><\/strong>&nbsp;traite le fichier de base de donn&eacute;es ma&icirc;tre et donne acc&egrave;s aux donn&eacute;es incorpor&eacute;es. Tous les composants de la base de donn&eacute;es SQL peuvent &ecirc;tre r&eacute;par&eacute;s, y compris les tableaux, les cl&eacute;s, les r&egrave;gles, les index, les valeurs par d&eacute;faut, les proc&eacute;dures stock&eacute;es, etc. Les fonctions de r&eacute;cup&eacute;ration &eacute;tendues comprennent des <strong>algorithmes avanc&eacute;s<\/strong> qui permettent de r&eacute;cup&eacute;rer les enregistrements supprim&eacute;s &agrave; partir du fichier t&eacute;l&eacute;charg&eacute;.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/cloud.stellarinfo.com\/fr\/StellarRepairforMSSQL.exe\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"67\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/FR-Download.jpg\" alt=\"Stellar\" class=\"wp-image-41064 apply-gradient-on-post-images\"><\/a><\/figure>\n<\/div><p>En outre, l&rsquo;outil de r&eacute;paration de base de donn&eacute;es SQL permet d&rsquo;enregistrer les composants de base de donn&eacute;es r&eacute;par&eacute;s dans plusieurs formats de fichiers, y compris <strong>XLS, HTML CSV<\/strong> ainsi que <strong>New Database<\/strong> ou <strong>Live Database<\/strong>. Le logiciel est <strong>test&eacute; et recommand&eacute; par Microsoft MVPs &agrave; travers le monde<\/strong>. Les formats de fichiers ind&eacute;pendants permettent d&rsquo;acc&eacute;der au contenu de la base de donn&eacute;es sans se connecter &agrave; l&rsquo;environnement du serveur. A l&rsquo;aide de l&rsquo;outil, vous pouvez &eacute;galement acc&eacute;der au contenu de la base de donn&eacute;es sauvegard&eacute; dans les fichiers de la base de donn&eacute;es secondaire.<\/p><p>Le MDF corrompu peut &ecirc;tre r&eacute;par&eacute; &agrave; l&rsquo;aide de\nl&rsquo;application en suivant trois &eacute;tapes simples : <strong>T&eacute;l&eacute;charger, r&eacute;parer <\/strong>et<strong>\nsauvegarder<\/strong>. L&rsquo;application Stellar Repair for MS SQL prend en charge toutes\nles versions de l&rsquo;application, &agrave; savoir <strong>SQL Server 2017, 2016, 2014, 2012,\n2008, 2008 (R2),<\/strong> etc. Une fois le fichier de base de donn&eacute;es ma&icirc;tre r&eacute;par&eacute;,\nvous pouvez l&rsquo;utiliser pour rattacher la base de donn&eacute;es SQL sans fichier\njournal des transactions en utilisant <strong>SQL Server Management Studio<\/strong> ou en\nex&eacute;cutant une requ&ecirc;te dans Transact-SQL.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Les fichiers de base de donn&eacute;es ma&icirc;tre (MDF) et les fichiers log&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/\">Continue reading <span class=\"screen-reader-text\">3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions<\/span><\/a><\/p>\n","protected":false},"author":15,"featured_media":41071,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1041],"tags":[],"class_list":["post-41052","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-recuperation-de-serveur-sql","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions<\/title>\n<meta name=\"description\" content=\"Rattachez la base de donn\u00e9es SQL en utilisant SQL Server Management Studio, T-SQL et un outil de r\u00e9paration de base de donn\u00e9es SQL. Ces m\u00e9thodes sont simples pour les utilisateurs SQL.\" \/>\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.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions\" \/>\n<meta property=\"og:description\" content=\"Rattachez la base de donn\u00e9es SQL en utilisant SQL Server Management Studio, T-SQL et un outil de r\u00e9paration de base de donn\u00e9es SQL. Ces m\u00e9thodes sont simples pour les utilisateurs SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-04T06:57:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-25T08:49:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/3-Simple-Methods-to-Attach-SQL-Database-without-Transaction-Log-File-FR.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Priyanka Chauhan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@priyanka66\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Chauhan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/\"},\"author\":{\"name\":\"Priyanka Chauhan\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470\"},\"headline\":\"3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions\",\"datePublished\":\"2019-06-04T06:57:49+00:00\",\"dateModified\":\"2025-10-25T08:49:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/\"},\"wordCount\":1138,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/3-Simple-Methods-to-Attach-SQL-Database-without-Transaction-Log-File-FR.jpg\",\"articleSection\":[\"R\u00e9paration de la base de donn\u00e9es SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/\",\"name\":\"3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/3-Simple-Methods-to-Attach-SQL-Database-without-Transaction-Log-File-FR.jpg\",\"datePublished\":\"2019-06-04T06:57:49+00:00\",\"dateModified\":\"2025-10-25T08:49:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470\"},\"description\":\"Rattachez la base de donn\u00e9es SQL en utilisant SQL Server Management Studio, T-SQL et un outil de r\u00e9paration de base de donn\u00e9es SQL. Ces m\u00e9thodes sont simples pour les utilisateurs SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/3-Simple-Methods-to-Attach-SQL-Database-without-Transaction-Log-File-FR.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/3-Simple-Methods-to-Attach-SQL-Database-without-Transaction-Log-File-FR.jpg\",\"width\":1000,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/\",\"name\":\"Stellar Data Recovery Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470\",\"name\":\"Priyanka Chauhan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g\",\"caption\":\"Priyanka Chauhan\"},\"description\":\"Priyanka is a technology expert working for key technology domains that revolve around Data Recovery and related software's. She got expertise on related subjects like SQL Database, Access Database, QuickBooks, and Microsoft Excel. Loves to write on different technology and data recovery subjects on regular basis. Technology freak who always found exploring neo-tech subjects, when not writing, research is something that keeps her going in life.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/priyankachouhan\/\",\"https:\/\/x.com\/priyanka66\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/priyanka\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions","description":"Rattachez la base de donn\u00e9es SQL en utilisant SQL Server Management Studio, T-SQL et un outil de r\u00e9paration de base de donn\u00e9es SQL. Ces m\u00e9thodes sont simples pour les utilisateurs SQL.","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.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/","og_locale":"en_US","og_type":"article","og_title":"3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions","og_description":"Rattachez la base de donn\u00e9es SQL en utilisant SQL Server Management Studio, T-SQL et un outil de r\u00e9paration de base de donn\u00e9es SQL. Ces m\u00e9thodes sont simples pour les utilisateurs SQL.","og_url":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2019-06-04T06:57:49+00:00","article_modified_time":"2025-10-25T08:49:08+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/3-Simple-Methods-to-Attach-SQL-Database-without-Transaction-Log-File-FR.jpg","type":"image\/jpeg"}],"author":"Priyanka Chauhan","twitter_card":"summary_large_image","twitter_creator":"@priyanka66","twitter_misc":{"Written by":"Priyanka Chauhan","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/"},"author":{"name":"Priyanka Chauhan","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470"},"headline":"3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions","datePublished":"2019-06-04T06:57:49+00:00","dateModified":"2025-10-25T08:49:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/"},"wordCount":1138,"commentCount":0,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/3-Simple-Methods-to-Attach-SQL-Database-without-Transaction-Log-File-FR.jpg","articleSection":["R\u00e9paration de la base de donn\u00e9es SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/","url":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/","name":"3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/3-Simple-Methods-to-Attach-SQL-Database-without-Transaction-Log-File-FR.jpg","datePublished":"2019-06-04T06:57:49+00:00","dateModified":"2025-10-25T08:49:08+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470"},"description":"Rattachez la base de donn\u00e9es SQL en utilisant SQL Server Management Studio, T-SQL et un outil de r\u00e9paration de base de donn\u00e9es SQL. Ces m\u00e9thodes sont simples pour les utilisateurs SQL.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/3-Simple-Methods-to-Attach-SQL-Database-without-Transaction-Log-File-FR.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/06\/3-Simple-Methods-to-Attach-SQL-Database-without-Transaction-Log-File-FR.jpg","width":1000,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/fr\/rattacher-une-base-de-donnees-sql-sans-ldf\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"3 m\u00e9thodes simples pour joindre une base de donn\u00e9es SQL sans fichier Log des transactions"}]},{"@type":"WebSite","@id":"https:\/\/www.stellarinfo.com\/blog\/#website","url":"https:\/\/www.stellarinfo.com\/blog\/","name":"Stellar Data Recovery Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470","name":"Priyanka Chauhan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g","caption":"Priyanka Chauhan"},"description":"Priyanka is a technology expert working for key technology domains that revolve around Data Recovery and related software's. She got expertise on related subjects like SQL Database, Access Database, QuickBooks, and Microsoft Excel. Loves to write on different technology and data recovery subjects on regular basis. Technology freak who always found exploring neo-tech subjects, when not writing, research is something that keeps her going in life.","sameAs":["https:\/\/www.linkedin.com\/in\/priyankachouhan\/","https:\/\/x.com\/priyanka66"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/priyanka\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/41052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=41052"}],"version-history":[{"count":11,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/41052\/revisions"}],"predecessor-version":[{"id":186557,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/41052\/revisions\/186557"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/41071"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=41052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=41052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=41052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}