SQL Server Data file Shrinking

5 pts.
Tags:
SQL Server 2008
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TechTalker
    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.
    2,310 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following