December 2, 2010 at 7:48 am
under what conditions we cannot shrink the fiiles in SQL server ?
then at that time what are the possible way to do ?
December 2, 2010 at 8:08 am
If you do a search of existing threads on this topic, you'll find that 99% of the time you should not be shrinking files because it hurts performance by fragmenting, uses resources, and does not address the the reason you want to fragment in the first place.
So, the question is why do you think you need to shrink files ?
What is your recovery model ? If FULL, how frequent are your t-log backups ?
December 2, 2010 at 8:36 am
Here are a few (of many) good reads on the topic:
By Paul Randal:
(he can't be more blunt than this)
http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(930)-data-file-shrink-does-not-affect-performance.aspx"> http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(930)-data-file-shrink-does-not-affect-performance.aspx
and
http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx"> http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx
Another good one by Tibor Karaszi:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp"> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
and, his "leaky roof" analogy, which is quite good.
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/02/25/leaking-roof-and-file-shrinking.aspx"> http://sqlblog.com/blogs/tibor_karaszi/archive/2007/02/25/leaking-roof-and-file-shrinking.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply