naren.ece2012 (7/28/2016)
Is there any other way other than shrinking???(It is a production database).
No. Reclaiming space = shrinking data files.
You could just leave it though. Free space in the data file doesn't cause any harm.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability