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>)
0 comments:
Post a Comment