{"id":2796,"date":"2011-07-11T22:40:33","date_gmt":"2011-07-11T21:40:33","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=2796"},"modified":"2019-09-13T14:36:57","modified_gmt":"2019-09-13T13:36:57","slug":"how-to-reduire-la-taille-du-journal-de-transactions-sur-disque","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/","title":{"rendered":"How-To: r\u00e9duire la taille du journal de transactions sur disque"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F2796&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F2796&#038;title=How-To%3A%20r%C3%A9duire%20la%20taille%20du%20journal%20de%20transactions%20sur%20disque\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=How-To%3A%20r%C3%A9duire%20la%20taille%20du%20journal%20de%20transactions%20sur%20disque&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F2796\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a><p>Deuxi\u00e8me how-to vid\u00e9o sur SQL Server, sur le sujet N\u00b01 remont\u00e9 dans les forums d&#8217;entraide SQL Server: comment r\u00e9duire la taille d&#8217;un journal de transactions sur disque.<\/p>\n<h2>Pourquoi il explose:<\/h2>\n<p>Avant de vouloir le r\u00e9duire, il faut comprendre pourquoi on en est arriv\u00e9 l\u00e0. A l&#8217;origine de ce probl\u00e8me, une option par d\u00e9faut de la base de donn\u00e9es qui s&#8217;appelle <strong>RECOVERY<\/strong>. Elle permet d&#8217;indiquer deux choses:<\/p>\n<ul>\n<li>Quels types de sauvegarde il sera possible d&#8217;effectuer sur la base.<\/li>\n<li>De quelle mani\u00e8re on recycle les transactions valid\u00e9es dans le journal de transactions.<\/li>\n<\/ul>\n<p><strong>Cette option a trois valeurs possibles:<\/strong><\/p>\n<ul>\n<li> <strong>FULL<\/strong>:toutes les transactions attendent d&#8217;\u00eatre sauvegard\u00e9es pour \u00eatre purg\u00e9es du fichier LDF. Il n&#8217;y a qu&#8217;une sauvegarde de transactions qui puisse les purger. Full est le mode par d\u00e9faut pour toute nouvelle base utilisateur.<\/li>\n<li><span style=\"text-decoration: underline;\"> <\/span><strong>SIMPLE<\/strong>: les transactions valid\u00e9es sont purg\u00e9es du journal \u00e0 intervalles r\u00e9guliers par un processus d&#8217;arri\u00e8re plan, le CHECKPOINT. Cette option correspond \u00e0 l&#8217;ancien mode &#8216;trunc log on checkpoint&#8217; qui existait en 7.0.<\/li>\n<li> <strong>BULK_LOGGED<\/strong>: permet de minimiser la journalisation de certains ordres de modification massive de donn\u00e9es, tels que les reconstructions d&#8217;indexes par exemple.<\/li>\n<\/ul>\n<p>Pour plus de d\u00e9tails sur ces diff\u00e9rents modes, voir les \u00e9pisodes <a href=\"http:\/\/blog.capdata.fr\/index.php\/modes-de-recuperation-et-journal-de-transactions-episode-1\/\">1<\/a> et <a href=\"http:\/\/blog.capdata.fr\/index.php\/modes-de-recuperation-et-journal-de-transactions-episode-2\">2<\/a> sur les modes de r\u00e9cup\u00e9ration.<\/p>\n<p>On peut lire cette option en utilisant la commande suivante:<\/p>\n<pre><span style=\"color: #0000ff;\">select DATABASEPROPERTYEX('CAPDATA','RECOVERY')\r\nGO\r\n\r\n<em>------------\r\nFULL<\/em><\/span><\/pre>\n<p>FULL est la valeur utilis\u00e9e par d\u00e9faut lors de la cr\u00e9ation d&#8217;une base. <strong>Ce qui signifie que si on ne fait jamais de sauvegardes de transactions sur une base dans ce mode, les transactions ne seront jamais purg\u00e9es du journal<\/strong> et au bout de 6 mois ou d&#8217;un an on arrive \u00e0 saturer l&#8217;espace disque, d&#8217;o\u00f9 le besoin de r\u00e9duire la taille de ce fichier. Il existe une technique pour le ramener \u00e0 sa taille initiale en moins de 2 minutes, comme expliqu\u00e9 dans le paragraphe suivant et dans la d\u00e9mo vid\u00e9o ci-dessus. Pour savoir si un backup transactionnel a d\u00e9j\u00e0 \u00e9t\u00e9 ex\u00e9cut\u00e9 sur une base, on peut interroger la table backupset de la base msdb:<\/p>\n<pre><span style=\"color: #0000ff;\">select backup_start_date, backup_finish_date, type, recovery_model\r\nfrom msdb.dbo.backupset where database_name = 'CAPDATA' and type = 'L'\r\n\r\n<em>backup_start_date              backup_finish_date         type          recovery_model\r\n<span style=\"color: #0000ff;\">--------------------------     -------------------------- ------------- -------------------<\/span><\/em><span style=\"color: #0000ff;\">\r\n<\/span><\/span><em><span style=\"color: #0000ff;\">2010-09-07 18:54:42.000\u00a0\u00a0 \u00a0       2010-09-07 18:54:52.000\u00a0\u00a0 \u00a0        L\u00a0\u00a0 \u00a0       FULL<\/span><\/em><\/pre>\n<h2>Comment le r\u00e9duire:<\/h2>\n<p><strong>En deux \u00e9tapes:<\/strong><\/p>\n<ul>\n<li><strong><span style=\"text-decoration: underline;\">Etape 1<\/span><\/strong>: on vide le journal de son contenu, ce qui revient \u00e0 recycler simplement les transactions \u00e0 l&#8217;int\u00e9rieur de l&#8217;enveloppe, sans la r\u00e9duire.<\/li>\n<li><strong><span style=\"text-decoration: underline;\">Etape 2<\/span><\/strong>: on r\u00e9duit l&#8217;enveloppe sur disque: une fois le journal vid\u00e9, il peut \u00eatre r\u00e9duit avec la commande DBCC SHRINKFILE ().<\/li>\n<\/ul>\n<p>Si vous n&#8217;avez jamais fait de sauvegarde de journal, il y a des chances pour que la taille du fichier LDF soit assez cons\u00e9quente. S&#8217;il s&#8217;agit de plusieurs dizaines ou centaines de Gb, et que vous faites des sauvegardes compl\u00e8tes tous les jours par exemple, \u00e7a ne sert \u00e0 rien de sauvegarder toutes ces transactions qui sont ent\u00e9rin\u00e9es depuis belle lurette. Si on regarde le contenu du journal de transactions avant de faire la manoeuvre;<\/p>\n<pre><span style=\"color: #0000ff;\">dbcc sqlperf(logspace)\r\n\r\n<em>Database Name       Log Size (Mb)       Log Space Used (%)      Status\r\n------------------  ------------------  ---------------------   ---------\r\n<\/em><\/span><em><span style=\"color: #0000ff;\">CAPDATA\u00a0\u00a0 \u00a0           25889,367\u00a0\u00a0 \u00a0            <span style=\"color: #ff0000;\">91,7766<\/span>\u00a0\u00a0 \u00a0          0<\/span><\/em><\/pre>\n<p>La technique consiste \u00e0 passer la base en mode SIMPLE:<\/p>\n<pre><span style=\"color: #0000ff;\">ALTER DATABASE [CAPDATA] SET RECOVERY SIMPLE\r\nGO<\/span><\/pre>\n<p>Un checkpoint est ex\u00e9cut\u00e9e automatiquement d\u00e8s la fin de la commande. Toutes les transactions valid\u00e9es sont purg\u00e9es du journal . Techniquement elles ne sont pas effac\u00e9es mais leur conteneur physique\u00a0 est r\u00e9initialis\u00e9 et peut \u00eatre r\u00e9utilis\u00e9:<\/p>\n<pre><span style=\"color: #0000ff;\">dbcc sqlperf(logspace)\r\n<\/span><\/pre>\n<pre><span style=\"color: #0000ff;\"><em>Database Name       Log Size (Mb)       Log Space Used (%)      Status\r\n------------------  ------------------  ---------------------   ---------\r\n<\/em><em>CAPDATA\u00a0\u00a0 \u00a0           25889,367\u00a0\u00a0 \u00a0            <\/em><\/span><span style=\"color: #ff0000;\"><em>1,192919<\/em><\/span><span style=\"color: #0000ff;\"><em>\u00a0\u00a0 \u00a0          0<\/em><\/span><\/pre>\n<p>Il ne reste plus qu&#8217;\u00e0 r\u00e9duire le fichier journal de transactions avec un DBCC SHRINKFILE. A cette \u00e9tape il faut d\u00e9cider quelle est la nouvelle taille \u00e0 donner au journal de transactions. Si on le r\u00e9duit \u00e0 son maximum, il risque de grandir \u00e0 nouveau pour atteindre sa taille de croisi\u00e8re, et si on souhaite de r\u00e9agrandir ensuite, la portion allou\u00e9e sera z\u00e9ro-initialis\u00e9e [1]. Id\u00e9alement il faudrait un historique d&#8217;utilisation de l&#8217;espace dans le journal pour savoir combien d&#8217;espace consomme la plus grosse transaction. Par exemple dans notre cas, 50Mb:<\/p>\n<pre><span style=\"color: #0000ff;\">select name from CAPDATA.sys.database_files where Type_DESC='LOG'<\/span><\/pre>\n<pre><span style=\"color: #0000ff;\"><em>name\r\n---------------\r\nGESTIMMO_log01<\/em><\/span><\/pre>\n<pre><span style=\"color: #0000ff;\">\r\ndbcc shrinkfile('GESTIMMO_log01',50)<\/span><\/pre>\n<pre><span style=\"color: #0000ff;\">\r\n<em>DbId\u00a0\u00a0 FileId\u00a0\u00a0\u00a0\u00a0\u00a0 CurrentSize MinimumSize UsedPages\u00a0\u00a0 EstimatedPages\r\n------ ----------- ----------- ----------- ----------- --------------\r\n5\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6400\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6400\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6400\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6400<\/em><\/span><\/pre>\n<p>6400 pages de 8192 octets = 50Mb, on a r\u00e9ussi \u00e0 r\u00e9duire l&#8217;enveloppe sur disque de 25Gb \u00e0 50Mb en quelques secondes.<\/p>\n<h2>Quoi faire ensuite:<\/h2>\n<p>Il faut d\u00e9cider de la strat\u00e9gie de backup \u00e0 adopter pour cette base: quelle quantit\u00e9 de donn\u00e9es est-il acceptable de perdre: 1 heure, 4 heures, 1 journ\u00e9e, 1 semaine ?<\/p>\n<ul>\n<li>Si la r\u00e9ponse est inf\u00e9rieure \u00e0 la fr\u00e9quence des backups complets, alors il faut repasser la base en mode FULL, relancer un backup complet pour r\u00e9initialiser la cha\u00eene de sauvegarde, puis planifier des backups de journaux via l&#8217;agent ou un plan de maintenance par exemple. Les backups de journaux permettent de garantir une restauration \u00e0 tout point dans le temps en mode de r\u00e9cup\u00e9ration FULL.<\/li>\n<li>Si la r\u00e9ponse est au moins \u00e9gale \u00e0 la fr\u00e9quence des backups complets, alors laisser la base en mode SIMPLE, et l&#8217;espace sera automatiquement recycl\u00e9.<\/li>\n<\/ul>\n<p>A suivre un autre How-To sur les probl\u00e8mes d&#8217;administration de base de SQL Server.<\/p>\n<p>A+ David B.<\/p>\n<h2>Notes:<\/h2>\n<p>[1]: l&#8217;initialisation instantan\u00e9e (IFI) ne s&#8217;applique qu&#8217;aux fichiers de donn\u00e9es MDF et NDF, pas aux journaux de transactions.<\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F2796&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F2796&#038;title=How-To%3A%20r%C3%A9duire%20la%20taille%20du%20journal%20de%20transactions%20sur%20disque\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=How-To%3A%20r%C3%A9duire%20la%20taille%20du%20journal%20de%20transactions%20sur%20disque&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F2796\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>Deuxi\u00e8me how-to vid\u00e9o sur SQL Server, sur le sujet N\u00b01 remont\u00e9 dans les forums d&#8217;entraide SQL Server: comment r\u00e9duire la taille d&#8217;un journal de transactions sur disque. Pourquoi il explose: Avant de vouloir le r\u00e9duire, il faut comprendre pourquoi on&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":7911,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[206,10],"class_list":["post-2796","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","tag-howto","tag-journal-de-transaction"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How-To: r\u00e9duire la taille du journal de transactions sur disque - Capdata TECH BLOG<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How-To: r\u00e9duire la taille du journal de transactions sur disque - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"Deuxi\u00e8me how-to vid\u00e9o sur SQL Server, sur le sujet N\u00b01 remont\u00e9 dans les forums d&#8217;entraide SQL Server: comment r\u00e9duire la taille d&#8217;un journal de transactions sur disque. Pourquoi il explose: Avant de vouloir le r\u00e9duire, il faut comprendre pourquoi on&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2011-07-11T21:40:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T13:36:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2011\/07\/log1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"664\" \/>\n\t<meta property=\"og:image:height\" content=\"329\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Baffaleuf\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Baffaleuf\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/\"},\"author\":{\"name\":\"David Baffaleuf\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\"},\"headline\":\"How-To: r\u00e9duire la taille du journal de transactions sur disque\",\"datePublished\":\"2011-07-11T21:40:33+00:00\",\"dateModified\":\"2019-09-13T13:36:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/\"},\"wordCount\":824,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"howto\",\"journal de transaction\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/\",\"name\":\"How-To: r\u00e9duire la taille du journal de transactions sur disque - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2011-07-11T21:40:33+00:00\",\"dateModified\":\"2019-09-13T13:36:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How-To: r\u00e9duire la taille du journal de transactions sur disque\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf\",\"name\":\"David Baffaleuf\",\"sameAs\":[\"http:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How-To: r\u00e9duire la taille du journal de transactions sur disque - Capdata TECH BLOG","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:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/","og_locale":"fr_FR","og_type":"article","og_title":"How-To: r\u00e9duire la taille du journal de transactions sur disque - Capdata TECH BLOG","og_description":"Deuxi\u00e8me how-to vid\u00e9o sur SQL Server, sur le sujet N\u00b01 remont\u00e9 dans les forums d&#8217;entraide SQL Server: comment r\u00e9duire la taille d&#8217;un journal de transactions sur disque. Pourquoi il explose: Avant de vouloir le r\u00e9duire, il faut comprendre pourquoi on&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2011-07-11T21:40:33+00:00","article_modified_time":"2019-09-13T13:36:57+00:00","og_image":[{"width":664,"height":329,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2011\/07\/log1.png","type":"image\/png"}],"author":"David Baffaleuf","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"David Baffaleuf","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/"},"author":{"name":"David Baffaleuf","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf"},"headline":"How-To: r\u00e9duire la taille du journal de transactions sur disque","datePublished":"2011-07-11T21:40:33+00:00","dateModified":"2019-09-13T13:36:57+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/"},"wordCount":824,"commentCount":3,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["howto","journal de transaction"],"articleSection":["SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/","url":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/","name":"How-To: r\u00e9duire la taille du journal de transactions sur disque - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2011-07-11T21:40:33+00:00","dateModified":"2019-09-13T13:36:57+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/how-to-reduire-la-taille-du-journal-de-transactions-sur-disque\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"How-To: r\u00e9duire la taille du journal de transactions sur disque"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/136297da9f61d6e4878abe0f48bc5fbf","name":"David Baffaleuf","sameAs":["http:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/dbaffaleuf\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/2796","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=2796"}],"version-history":[{"count":63,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/2796\/revisions"}],"predecessor-version":[{"id":7912,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/2796\/revisions\/7912"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7911"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=2796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=2796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=2796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}