T-SQLhttp://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)Re: probleme shrink in sql server 2000 sp2http://sqlserver.ro/forums/thread/8940.aspxMon, 05 Sep 2011 09:38:01 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8940neo0http://sqlserver.ro/forums/thread/8940.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8940alte idei?<br>Re: probleme shrink in sql server 2000 sp2http://sqlserver.ro/forums/thread/8939.aspxMon, 05 Sep 2011 08:49:55 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8939neo0http://sqlserver.ro/forums/thread/8939.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8939nici o schimbare...<br>Re: probleme shrink in sql server 2000 sp2http://sqlserver.ro/forums/thread/8938.aspxMon, 05 Sep 2011 08:28:38 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8938Diana0http://sqlserver.ro/forums/thread/8938.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8938Ruleaza sp_spaceused cu parametrul "updateusage" = "true" - http://msdn.microsoft.com/en-us/library/ms188776.aspx <br />Vezi daca te ajuta <br />http://stackoverflow.com/questions/1368354/excessive-reserved-space-on-sql-server <br />http://www.sqlservercentral.com/Forums/Topic600468-5-2.aspxprobleme shrink in sql server 2000 sp2http://sqlserver.ro/forums/thread/8937.aspxMon, 05 Sep 2011 06:28:51 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8937neo0http://sqlserver.ro/forums/thread/8937.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8937salut, <br><br>Am un sql server 2000 sp 2 cu o baza de date de 30 GB.<br><br>Am facut mentenanta si am adus la jumatate valoarea indexului si a datelor prin defrag-ul indecsilor de pe tabele.<br>Problema este ca spatiul rezervat "rezerved" a ramas acelasi. <br>Am facut shrink de mdf din linie de comanda (dbcc shrinkfile 'filename', target size) - fara alte optiuni gen truncate only, backup full si tot nu a scazut spatiul ci din contra, valoarea unalocated space a trecut pe minus (motiv ptr care am fost nevoit sa maresc dimensiunea mdf-ului (pentru ca spatiul alocat era aproape de 100 %))<br><br>Cum pot sa scad valoarea "reserved" (tinand cont ca am redus dimensiunile ptr indecsi si pentru date cam la jumatate inainte de mentenanta) ?<br><br>Multumesc.<br>