Shrink Database File

By Using This query we can reduce database file

Firstly we should get File Name by Using This


with TblSpace as
(
    select
        Name,
        size * 8.0 / 1024 as TotalSize,
        fileproperty(name, 'SpaceUsed') * 8.0 / 1024 as UsedSpace
    from sys.database_files
)
select
    Name,
    TotalSize,
    UsedSpace,
    convert(decimal(5, 2), UsedSpace / TotalSize * 100) as UsedSpacePer
from TblSpace

Get File Name and use that file name in this query to reduce 

dbcc shrinkfile(<Database_File_Name>, <Target_Size_in_MB>)