Shrink database and check its progress

Claiming space from a SQL Server database is not like deleting all rows from a table or truncate it. Please follow the instructions if you want to reclaim your disk space.

1. Run Sql Command:
   DBCC SHRINKDATABASE (MyDBName, 10 )
   Here MyDBName is a valid database name and 10 is the percentage of reserved free space.
2. Run following command to check percentage done:
   select percent_complete, total_elapsed_time, estimated_completion_time, * from sys.dm_exec_requests where command = 'DbccFilesCompact'