{"id":2045,"date":"2026-06-17T07:02:03","date_gmt":"2026-06-17T07:02:03","guid":{"rendered":"https:\/\/www.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/"},"modified":"2026-07-25T14:16:58","modified_gmt":"2026-07-25T12:16:58","password":"","slug":"cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql","status":"publish","type":"docs","link":"https:\/\/www.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/","title":{"rendered":"Cum mic\u0219orez fi\u0219ierul log al unei baze de date MSSQL?"},"content":{"rendered":"<p>Ruleaz\u0103 comenzile de mai jos (\u00eenlocuie\u0219te <code>BAZADEDATE<\/code> \u0219i <code>NUME_LOG<\/code>). Se comut\u0103 pe \u201eSimple recovery&#8221;, se mic\u0219oreaz\u0103 logul, apoi se revine la \u201eFull recovery&#8221;:<\/p>\n<pre>USE BAZADEDATE\nGO\nALTER DATABASE BAZADEDATE SET RECOVERY SIMPLE\nGO\nDBCC SHRINKFILE ('NUME_LOG_log', 1)\nGO\nALTER DATABASE BAZADEDATE SET RECOVERY FULL\nGO<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Ruleaz\u0103 comenzile de mai jos (\u00eenlocuie\u0219te BAZADEDATE \u0219i NUME_LOG). Se comut\u0103 pe \u201eSimple recovery&#8221;, se mic\u0219oreaz\u0103 logul, apoi se revine la \u201eFull recovery&#8221;: USE BAZADEDATE GO ALTER DATABASE BAZADEDATE SET RECOVERY SIMPLE GO DBCC SHRINKFILE (&#8216;NUME_LOG_log&#8217;, 1) GO ALTER DATABASE BAZADEDATE SET RECOVERY FULL GO<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"whmcs_kb_id":390,"footnotes":""},"doc_category":[191],"doc_tag":[231,254,392,268],"class_list":["post-2045","docs","type-docs","status-publish","hentry","doc_category-mssql","doc_tag-baza-de-date","doc_tag-management","doc_tag-mssql","doc_tag-optimizare"],"year_month":"2026-11","word_count":49,"total_views":"28","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Adrian Firican","author_nicename":"techeditor1","author_url":"https:\/\/www.hostx.ro\/kb\/author\/techeditor1\/"},"doc_category_info":[{"term_name":"MSSQL","term_url":"https:\/\/www.hostx.ro\/kb\/docs-category\/mssql\/"}],"doc_tag_info":[{"term_name":"baz\u0103 de date","term_url":"https:\/\/www.hostx.ro\/kb\/docs-tag\/baza-de-date\/"},{"term_name":"management","term_url":"https:\/\/www.hostx.ro\/kb\/docs-tag\/management\/"},{"term_name":"MSSQL","term_url":"https:\/\/www.hostx.ro\/kb\/docs-tag\/mssql\/"},{"term_name":"optimizare","term_url":"https:\/\/www.hostx.ro\/kb\/docs-tag\/optimizare\/"}],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cum mic\u0219orez logul bazei de date MSSQL - Centrul de suport HostX<\/title>\n<meta name=\"description\" content=\"G\u0103se\u0219te cum s\u0103 mic\u0219orezi fi\u0219ierul log MSSQL cu comenzi SQL. Schimb\u0103 recovery mode, compacteaz\u0103 logul \u0219i revino la set\u0103rile ini\u021biale.\" \/>\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.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/\" \/>\n<meta property=\"og:locale\" content=\"ro_RO\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cum mic\u0219orez logul bazei de date MSSQL - Centrul de suport HostX\" \/>\n<meta property=\"og:description\" content=\"G\u0103se\u0219te cum s\u0103 mic\u0219orezi fi\u0219ierul log MSSQL cu comenzi SQL. Schimb\u0103 recovery mode, compacteaz\u0103 logul \u0219i revino la set\u0103rile ini\u021biale.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/\" \/>\n<meta property=\"og:site_name\" content=\"Centrul de suport HostX\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-25T12:16:58+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\\\/\",\"url\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\\\/\",\"name\":\"Cum mic\u0219orez logul bazei de date MSSQL - Centrul de suport HostX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/#website\"},\"datePublished\":\"2026-06-17T07:02:03+00:00\",\"dateModified\":\"2026-07-25T12:16:58+00:00\",\"description\":\"G\u0103se\u0219te cum s\u0103 mic\u0219orezi fi\u0219ierul log MSSQL cu comenzi SQL. Schimb\u0103 recovery mode, compacteaz\u0103 logul \u0219i revino la set\u0103rile ini\u021biale.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\\\/#breadcrumb\"},\"inLanguage\":\"ro-RO\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Prima pagin\u0103\",\"item\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"InfoCentru\",\"item\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/docs\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Cum mic\u0219orez fi\u0219ierul log al unei baze de date MSSQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/\",\"name\":\"Centrul de suport HostX\",\"description\":\"tutoriale gazduire web, domenii web \u0219i servere\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hostx.ro\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ro-RO\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cum mic\u0219orez logul bazei de date MSSQL - Centrul de suport HostX","description":"G\u0103se\u0219te cum s\u0103 mic\u0219orezi fi\u0219ierul log MSSQL cu comenzi SQL. Schimb\u0103 recovery mode, compacteaz\u0103 logul \u0219i revino la set\u0103rile ini\u021biale.","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.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/","og_locale":"ro_RO","og_type":"article","og_title":"Cum mic\u0219orez logul bazei de date MSSQL - Centrul de suport HostX","og_description":"G\u0103se\u0219te cum s\u0103 mic\u0219orezi fi\u0219ierul log MSSQL cu comenzi SQL. Schimb\u0103 recovery mode, compacteaz\u0103 logul \u0219i revino la set\u0103rile ini\u021biale.","og_url":"https:\/\/www.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/","og_site_name":"Centrul de suport HostX","article_modified_time":"2026-07-25T12:16:58+00:00","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/","url":"https:\/\/www.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/","name":"Cum mic\u0219orez logul bazei de date MSSQL - Centrul de suport HostX","isPartOf":{"@id":"https:\/\/www.hostx.ro\/kb\/#website"},"datePublished":"2026-06-17T07:02:03+00:00","dateModified":"2026-07-25T12:16:58+00:00","description":"G\u0103se\u0219te cum s\u0103 mic\u0219orezi fi\u0219ierul log MSSQL cu comenzi SQL. Schimb\u0103 recovery mode, compacteaz\u0103 logul \u0219i revino la set\u0103rile ini\u021biale.","breadcrumb":{"@id":"https:\/\/www.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/#breadcrumb"},"inLanguage":"ro-RO","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.hostx.ro\/kb\/cum-se-poate-micsora-fisierul-log-pentru-o-baza-de-date-mssql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Prima pagin\u0103","item":"https:\/\/www.hostx.ro\/kb\/"},{"@type":"ListItem","position":2,"name":"InfoCentru","item":"https:\/\/www.hostx.ro\/kb\/docs\/"},{"@type":"ListItem","position":3,"name":"Cum mic\u0219orez fi\u0219ierul log al unei baze de date MSSQL?"}]},{"@type":"WebSite","@id":"https:\/\/www.hostx.ro\/kb\/#website","url":"https:\/\/www.hostx.ro\/kb\/","name":"Centrul de suport HostX","description":"tutoriale gazduire web, domenii web \u0219i servere","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hostx.ro\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ro-RO"}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/docs\/2045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/comments?post=2045"}],"version-history":[{"count":2,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/docs\/2045\/revisions"}],"predecessor-version":[{"id":4894,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/docs\/2045\/revisions\/4894"}],"wp:attachment":[{"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/media?parent=2045"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/doc_category?post=2045"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hostx.ro\/kb\/wp-json\/wp\/v2\/doc_tag?post=2045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}