http://sqlserver.ro/forums/14/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/8550.aspxTue, 07 Dec 2010 08:35:09 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8550cosmin.luca0http://sqlserver.ro/forums/thread/8550.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8550Baza de date are model full de recovery. Shrink am facut la ambele fisiere, ceea ce nu e indicat.<br>http://sqlserver.ro/forums/thread/8544.aspxFri, 03 Dec 2010 10:11:24 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8544xmldeveloper0http://sqlserver.ro/forums/thread/8544.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8544Ce recovery model are baza de date?<br><table cellpadding="0" cellspacing="0"><tr style="vertical-align:top;line-height:normal;"><td style="width:40px;text-align:right;"><pre style="font-family:courier new;font-size:11px;color:gray;margin:0px;padding:2px;">1<br>2<br>3<br>4<br> </pre></td><td><pre style="margin:0px;padding:2px 2px 2px 8px;"><span style="color:Black;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;"><span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">SELECT</span><br>recovery_model_desc<br><span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">FROM</span> sys.databases<br><span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">WHERE</span> [name]=<span style="color:Red;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">'MyDatabase'</span>;</span></pre></td></tr></table><br>Cum ati facut shrink? Daca doar este trunchiat log-ul nu ar trebui sa va afecteze indecsii. <br><br><br><br><br><br>http://sqlserver.ro/forums/thread/8539.aspxThu, 02 Dec 2010 08:42:28 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8539Diana0http://sqlserver.ro/forums/thread/8539.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8539Ce probleme ai cu aceasta dimensiune? <br />Te-ai convins singur de "avantajele" shrink in cazul tau. Totusi uite si aici <br />http://www.sqlskills.com/BLOGS/PAUL/category/Shrink.aspx#p7http://sqlserver.ro/forums/thread/8538.aspxThu, 02 Dec 2010 08:18:40 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8538cosmin.luca0http://sqlserver.ro/forums/thread/8538.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=8538Salut! Am o baza de date de 5.7 GB (mdf). Am rulat pe ea un script pentru defragmentarea indecsilor si a ajuns la 8.4 GB si log la 3.4 GB. Mie mi se pare prea mult. I-am dat shrink, a ajuns la 4 GB (mdf, logul 1MB) dar indecsii s-au fragmentat la loc. Nu am mai lucrat cu baze de date asa de mari. Exista vreo posibilitate de a avea indecsii defragmentati si baza de date sa ocupe mai putin spatiu? <br>