http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/1065.aspxMon, 27 Nov 2006 12:29:46 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1065xmldeveloper0http://sqlserver.ro/forums/thread/1065.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=1065<p>Salut Razvan,</p><p>Raspunsurile pentru intrebare le poti gasi aici:</p><p><a href="http://support.microsoft.com/kb/873235/en-us">How to stop the <span class="hl">transaction</span> <span class="hl">log</span> of a <span class="hl">SQL</span> <span class="hl">Server</span> database from growing unexpectedly </a></p><p><a href="http://support.microsoft.com/kb/272318/en-us">INF: Shrinking the <span class="hl">Transaction</span> <span class="hl">Log</span> in <span class="hl">SQL</span> <span class="hl">Server</span> 2000 with DBCC SHRINKFILE </a></p><p>&nbsp;</p>http://sqlserver.ro/forums/thread/1057.aspxMon, 27 Nov 2006 10:13:38 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:1057RazvanH0http://sqlserver.ro/forums/thread/1057.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=1057<p>Rulez acest cod pe o baza de date hostata pe un SQL Server 2000 cu SP4&nbsp;</p><p>BACKUP LOG [&lt;database_name&gt;] WITH TRUNCATE_ONLY</p><p>evident &lt;database_name&gt; este doar un substitut pentru numele real a bazei de date pe care il scriu eu in t-sql</p><p>Problema este ca din ditamai transaction logul de 1 GB el taie cativa mega, unde in log exista 92% spatiu liber. Stie cineva o metoda eficienta de a &quot;taia&quot; transaction logurile in mod eficient?&nbsp;</p><p>&nbsp;Multumesc<br />&nbsp;</p>