Home > IT Answers > SQL Server Data file Shrinking
asenthil17
5 pts.
 SQL Server Data file Shrinking
SQL Server 2008 Datafile Shrinking
We have the database in SQL server 2008 and size is nearly 160 GB.We have configured Transactional Replication on this database(Only few tables).There are 50% of free space available on Datafile. To reduce the disk usage We try to shrink the datafile, but unfortunately the file does't shrunken.The output of the process is  DbId FileId  CurrentSize  MinimumSize  UsedPages EstimatedPages 5        1       20711032      12800         9918384      9918384

 Any advise would be appreciated.



Software/Hardware used:
Windows server 2008 and SQL server 2008
ASKED: January 17, 2012  4:28 PM
UPDATED: February 28, 2012  11:33 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I just found an interesting article (http://www.sqlskills.com/blogs/paul/post/why-you-should-not-shrink-your-data-files.aspx) on why you should not shrink your data files and what you should do instead to reclaim disk space. Thought I would share this information and see what others have to say about shrinking SQL Server data files versus building a new file group and moving the data.

TechTalker
 2,280 pts.