InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 23:29:29 GMT20http://www.sqlservercentral.com/Forums/Topic1421486-1550-1.aspx[quote][b]SQLCrazyCertified (2/19/2013)[/b][hr]Hi, sorry, I was not aware of this, anyway, with truncate only option only available for sql 2005 right? because I know they took away this option for 2008 and above. [/quote]SQL 2000, SQL 2005, SQL 2008, SQL 2008 R2, SQL 2012, not on the deprecation list, so 2 more versions at least, personally I doubt it'll be removed, too useful and no good reason to remove it. Maybe earlier too, never worked on SQL 7 though.Tue, 19 Feb 2013 06:54:10 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1421486-1550-1.aspxHi,It is still there in Shrink File .I use 2008 R2.Tue, 19 Feb 2013 05:23:56 GMTmwaghhttp://www.sqlservercentral.com/Forums/Topic1421486-1550-1.aspx[quote][b]anthony.green (2/19/2013)[/b][hr][quote][b]SQLCrazyCertified (2/19/2013)[/b][hr][quote][b]mwagh (2/19/2013)[/b][hr]Thanks!! works in my case as i have a lot initially allocated space which was never touched.[/quote]Hi, sorry, I was not aware of this, anyway, with truncate only option only available for sql 2005 right? because I know they took away this option for 2008 and above. Just curious which version you are using.SueTons.[/quote]TRUNCATE ONLY been removed from the BACKUP LOG command, but not from DBCC SHRINKFILE[/quote]Got it. Thank you.SueTons.Tue, 19 Feb 2013 05:17:57 GMTSQLCrazyCertifiedhttp://www.sqlservercentral.com/Forums/Topic1421486-1550-1.aspx[quote][b]SQLCrazyCertified (2/19/2013)[/b][hr][quote][b]mwagh (2/19/2013)[/b][hr]Thanks!! works in my case as i have a lot initially allocated space which was never touched.[/quote]Hi, sorry, I was not aware of this, anyway, with truncate only option only available for sql 2005 right? because I know they took away this option for 2008 and above. Just curious which version you are using.SueTons.[/quote]TRUNCATE ONLY been removed from the BACKUP LOG command, but not from DBCC SHRINKFILETue, 19 Feb 2013 05:15:04 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1421486-1550-1.aspx[quote][b]mwagh (2/19/2013)[/b][hr]Thanks!! works in my case as i have a lot initially allocated space which was never touched.[/quote]Hi, sorry, I was not aware of this, anyway, with truncate only option only available for sql 2005 right? because I know they took away this option for 2008 and above. Just curious which version you are using.SueTons.Tue, 19 Feb 2013 05:13:14 GMTSQLCrazyCertifiedhttp://www.sqlservercentral.com/Forums/Topic1421486-1550-1.aspxThanks!! works in my case as i have a lot initially allocated space which was never touched.Tue, 19 Feb 2013 02:55:37 GMTmwaghhttp://www.sqlservercentral.com/Forums/Topic1421486-1550-1.aspxCorrect, shrink with truncate only doesn't fragment indexes, but it also may not reduce space usage if the space and the end of the file is in use.Tue, 19 Feb 2013 02:51:16 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1421486-1550-1.aspxthanks for your reply.I know it is not recommended as it will cause fragmentation of indexes but i need to free up some space.As per http://msdn.microsoft.com/en-us//library/ms189493.aspxthe TruncateOnly clause "Releases all free space at the end of the file to the operating system but does not perform any page movement inside the file"So i was hoping that this should not create fragmentation as there is no movement of pages. :unsure:Tue, 19 Feb 2013 02:44:48 GMTmwaghhttp://www.sqlservercentral.com/Forums/Topic1421486-1550-1.aspx[quote][b]mwagh (2/19/2013)[/b][hr]Hi,I wanted to shrink a data file with the truncate only clause.Will i require to rebuild my indexes?[/quote]Shrinking data file is not recommended as it will create fragmentation and it affects the performance. What's the reason you are trying to shrink?SueTons.Tue, 19 Feb 2013 02:36:05 GMTSQLCrazyCertifiedhttp://www.sqlservercentral.com/Forums/Topic1421486-1550-1.aspxHi,I wanted to shrink a data file with the truncate only clause.Will i require to rebuild my indexes?Tue, 19 Feb 2013 02:30:40 GMTmwagh