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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!