{"id":22138,"date":"2021-05-18T07:29:12","date_gmt":"2021-05-18T07:29:12","guid":{"rendered":"https:\/\/ckonnect.in\/solidworks\/?p=22138"},"modified":"2022-04-21T17:29:59","modified_gmt":"2022-04-21T11:59:59","slug":"shrink-your-solidworks-pdm-sql-transaction-log","status":"publish","type":"post","link":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/","title":{"rendered":"Shrink your SOLIDWORKS PDM SQL Transaction Log"},"content":{"rendered":"<div>Within Microsoft SQL, every SOLIDWORKS PDM vault database has a transaction log associated with it that records the modifications to the database.<\/div>\n<div style=\"margin-top: 15px;\">In some scenarios, if this log grows large it can cause performance issues within SQL and the vault. If you\u2019ve recently changed the recovery model for the <a href=\"https:\/\/ckonnect.in\/solidworks\/solidworks-pdm-3\/\">SOLIDWORKS PDM<\/a> vault DB from full to simple, we can reduce the size of the transaction log with a shrink action.<\/div>\n<h3 style=\"margin-top: 15px;\">How to shrink log file in SQL server<\/h3>\n<ul style=\"margin-top: 15px;\">\n<li>Login to the SQL Server Management Studio using the sa (system administrator) account<\/li>\n<\/ul>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/05\/p1.jpg\" alt=\"How to shrink log file in SQL server\" width=\"370\" height=\"304\" \/><\/p>\n<ul style=\"margin-top: 15px;\">\n<li>Expand the Databases folder, Select the vault DB, Right-click, Tasks &gt; Shrink &gt; Files<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone\" src=\"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/05\/p2.jpg\" alt=\" shrink log file in SQL server\" width=\"424\" height=\"207\" \/><\/p>\n<ul style=\"margin-top: 15px;\">\n<li>For File Type select Log, and click OK<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone\" src=\"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/05\/p3.jpg\" alt=\"How to shrink log file in SQL server \" width=\"416\" height=\"261\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Within Microsoft SQL, every SOLIDWORKS PDM vault database has a transaction log associated with it that records the modifications to the database. In some scenarios, if this log grows large it can cause performance issues within SQL and the vault. If you\u2019ve recently changed the recovery model for the SOLIDWORKS PDM vault DB from full &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Shrink your SOLIDWORKS PDM SQL Transaction Log&#8221;<\/span><\/a><\/p>\n","protected":false},"author":49,"featured_media":22145,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[188],"tags":[215],"class_list":["post-22138","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pdm","tag-manage1","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to shrink log file in SQL server - SOLIDWORKS PDM<\/title>\n<meta name=\"description\" content=\"Here in this blog we discussed a step by step process for &#039; How to shrink SOLIDWORKS PDM log file in SQL server?&#039; in detailed way.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to shrink log file in SQL server - SOLIDWORKS PDM\" \/>\n<meta property=\"og:description\" content=\"Here in this blog we discussed a step by step process for &#039; How to shrink SOLIDWORKS PDM log file in SQL server?&#039; in detailed way.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/\" \/>\n<meta property=\"og:site_name\" content=\"Conceptia\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-18T07:29:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-21T11:59:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/05\/p2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"424\" \/>\n\t<meta property=\"og:image:height\" content=\"207\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Shridevi V Patil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shridevi V Patil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to shrink log file in SQL server - SOLIDWORKS PDM","description":"Here in this blog we discussed a step by step process for ' How to shrink SOLIDWORKS PDM log file in SQL server?' in detailed way.","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:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/","og_locale":"en_US","og_type":"article","og_title":"How to shrink log file in SQL server - SOLIDWORKS PDM","og_description":"Here in this blog we discussed a step by step process for ' How to shrink SOLIDWORKS PDM log file in SQL server?' in detailed way.","og_url":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/","og_site_name":"Conceptia","article_published_time":"2021-05-18T07:29:12+00:00","article_modified_time":"2022-04-21T11:59:59+00:00","og_image":[{"width":424,"height":207,"url":"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/05\/p2.jpg","type":"image\/jpeg"}],"author":"Shridevi V Patil","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Shridevi V Patil","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/#article","isPartOf":{"@id":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/"},"author":{"name":"Shridevi V Patil","@id":"https:\/\/ckonnect.in\/solidworks\/#\/schema\/person\/9be2557c7c40612d504f632960daa11f"},"headline":"Shrink your SOLIDWORKS PDM SQL Transaction Log","datePublished":"2021-05-18T07:29:12+00:00","dateModified":"2022-04-21T11:59:59+00:00","mainEntityOfPage":{"@id":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/"},"wordCount":121,"commentCount":0,"publisher":{"@id":"https:\/\/ckonnect.in\/solidworks\/#organization"},"image":{"@id":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/#primaryimage"},"thumbnailUrl":"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/05\/p2.jpg","keywords":["manage1"],"articleSection":["PDM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/","url":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/","name":"How to shrink log file in SQL server - SOLIDWORKS PDM","isPartOf":{"@id":"https:\/\/ckonnect.in\/solidworks\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/#primaryimage"},"image":{"@id":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/#primaryimage"},"thumbnailUrl":"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/05\/p2.jpg","datePublished":"2021-05-18T07:29:12+00:00","dateModified":"2022-04-21T11:59:59+00:00","description":"Here in this blog we discussed a step by step process for ' How to shrink SOLIDWORKS PDM log file in SQL server?' in detailed way.","breadcrumb":{"@id":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/#primaryimage","url":"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/05\/p2.jpg","contentUrl":"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/05\/p2.jpg","width":424,"height":207,"caption":"How to shrink log file in SQL server - SOLIDWORKS PDM"},{"@type":"BreadcrumbList","@id":"https:\/\/ckonnect.in\/solidworks\/shrink-your-solidworks-pdm-sql-transaction-log\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ckonnect.in\/solidworks\/"},{"@type":"ListItem","position":2,"name":"Shrink your SOLIDWORKS PDM SQL Transaction Log"}]},{"@type":"WebSite","@id":"https:\/\/ckonnect.in\/solidworks\/#website","url":"https:\/\/ckonnect.in\/solidworks\/","name":"Conceptia","description":"","publisher":{"@id":"https:\/\/ckonnect.in\/solidworks\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ckonnect.in\/solidworks\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ckonnect.in\/solidworks\/#organization","name":"Conceptia","url":"https:\/\/ckonnect.in\/solidworks\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ckonnect.in\/solidworks\/#\/schema\/logo\/image\/","url":"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/09\/cropped-Conceptia-White-background.png","contentUrl":"https:\/\/ckonnect.in\/solidworks\/wp-content\/uploads\/2021\/09\/cropped-Conceptia-White-background.png","width":496,"height":46,"caption":"Conceptia"},"image":{"@id":"https:\/\/ckonnect.in\/solidworks\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ckonnect.in\/solidworks\/#\/schema\/person\/9be2557c7c40612d504f632960daa11f","name":"Shridevi V Patil","url":"https:\/\/ckonnect.in\/solidworks\/author\/shridevi-v-patil\/"}]}},"_links":{"self":[{"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/posts\/22138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/users\/49"}],"replies":[{"embeddable":true,"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/comments?post=22138"}],"version-history":[{"count":1,"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/posts\/22138\/revisions"}],"predecessor-version":[{"id":33639,"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/posts\/22138\/revisions\/33639"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/media\/22145"}],"wp:attachment":[{"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/media?parent=22138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/categories?post=22138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ckonnect.in\/solidworks\/wp-json\/wp\/v2\/tags?post=22138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}