http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/6399.aspxFri, 12 Dec 2008 06:27:16 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6399neo0http://sqlserver.ro/forums/thread/6399.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=6399asta e de retinut. multam andreihttp://sqlserver.ro/forums/thread/6392.aspxThu, 11 Dec 2008 15:21:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6392ignatandrei0http://sqlserver.ro/forums/thread/6392.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=6392<BLOCKQUOTE><div><img src="http://sqlserver.ro/Themes/default/images/icon-quote.gif"> <strong>neo:</strong></div><div>a mers ; insa tot nu imi explic manifestarea; cred ca totusi este pana la urma o problema legata de shrink specifica in sesnsul ca am facut ce zice microsoft de mai multe ori si a n-a oara s-a rezolvat totusi...?!?!?</div></BLOCKQUOTE><br>La un moment dat aveam si eu aceeasi problema, si, dupa ce am citit de am innebunit pe net, gasisem undeva (? nu mai stiu) ca trebuie sa ii dai o comanda SQL valida inainte... asa ca faceam urmatoarea smecherie<br>cream tabela test<br>insert test<br>shring<br>drop table test <br><br>Mergea de minune ...<br>http://sqlserver.ro/forums/thread/6389.aspxThu, 11 Dec 2008 14:44:21 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6389neo0http://sqlserver.ro/forums/thread/6389.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=6389posibil multumeschttp://sqlserver.ro/forums/thread/6388.aspxThu, 11 Dec 2008 14:39:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6388Diana0http://sqlserver.ro/forums/thread/6388.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=6388<P>Poate ca ai dat peste una din situatiile de aici:</P> <P><A href="http://msdn.microsoft.com/en-us/library/ms345414(SQL.90).aspx">http://msdn.microsoft.com/en-us/library/ms345414(SQL.90).aspx</A></P>http://sqlserver.ro/forums/thread/6386.aspxThu, 11 Dec 2008 14:19:59 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6386neo0http://sqlserver.ro/forums/thread/6386.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=6386a mers ; insa tot nu imi explic manifestarea; cred ca totusi este pana la urma o problema legata de shrink specifica in sesnsul ca am facut ce zice microsoft de mai multe ori si a n-a oara s-a rezolvat totusi...?!?!?http://sqlserver.ro/forums/thread/6120.aspxMon, 10 Nov 2008 19:38:15 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6120neo0http://sqlserver.ro/forums/thread/6120.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=6120<P>am facul un ful bck , am dat shrink din comanda , n-a mers, am facut bck de log urmat la fel de shrink din linie de comanda si nu a mers</P> <P>ai idee diana care e problema ? sau mai bine zis cum se rezolva?</P> <P>&nbsp;</P> <P>merci</P>http://sqlserver.ro/forums/thread/5949.aspxMon, 27 Oct 2008 18:57:16 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5949Diana0http://sqlserver.ro/forums/thread/5949.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=5949<P>Verifica fragmentarea logului si urmeaza sfaturile de la punctul 8 din lista de mai jos.</P> <P><A href="http://sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx">http://sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx</A></P>http://sqlserver.ro/forums/thread/5946.aspxMon, 27 Oct 2008 16:17:56 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5946neo0http://sqlserver.ro/forums/thread/5946.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=5946<P>merci mult de tot kata...(raman dator...)</P> <P>alte variante?</P> <P>multumesc</P>http://sqlserver.ro/forums/thread/5944.aspxMon, 27 Oct 2008 15:33:22 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5944katalyn0http://sqlserver.ro/forums/thread/5944.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=5944vezi <a href="http://sqlserver.ro/forums/thread/3630.aspx">aici&nbsp; </a>si <a href="http://msdn.microsoft.com/en-us/library/aa258824%28SQL.80%29.aspx">aici</a><br>http://sqlserver.ro/forums/thread/5943.aspxMon, 27 Oct 2008 14:53:53 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:5943neo0http://sqlserver.ro/forums/thread/5943.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=5943<P>Salut,</P> <P>Am si eu o problema:</P> <P>- am o baza de date care are setat recovery model "full".</P> <P>La full, eu stiu ca scade dimensiunea lui (al loguli: .ldf) daca fac backup full. </P> <P>Am facut backup full de db intai si nu a scazut, apoi am facul backup de log si tot nu a scazut.</P> <P>la sp_spaceused&nbsp; log-ul are vreao 60 GB si mdf-ul vreo 500 MB (pe platforma SQL 2005).</P> <P>Cum as putea aduce log-ul la o dimensiune minima?&nbsp; (am incercat si cu dbcc shrinkfile optiunea truncateonly si degeaba..)</P> <P>&nbsp;</P> <P>multumesc</P>