In My production environment , every six month cycle we are replace the database server.whenever replace the database we are truncate all the unwanted transaction data. My problem is after truncate the data i try to shrink the database. But not reduce the MDF file size.i tried all the possibilities like
- Change the database recover mode in simple i tried , that time also not working
- Index rebuild all the tables
- mdf and ldf separately tried
- backup file got reduced but mdf file not reduced.
please give solution for above this problem.