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.
Windows server 2008 and SQL server 2008
January 17, 2012 4:28 PM
February 28, 2012 11:33 AM