SQL Server Data file 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  [...]

Answer Question   |  February 28, 2012  4:28 PM
SQL Server 2008 Datafile Shrinking