Hi -- I'm doing a SSMA migration from Sybase to SQL and i'm midway to finishing. I'm just curious why the sum data and index space used has a huge discrepancy with what is reported in sys.database_files using fileproperty() SpaceUsed function?
The sum in Object Explorer details is just 370 GB which is very close to the 500 GB size from Sybase. The file however is reported as 1.7 TB + already.
I'm aware of DBCC UPDATEUSAGE and i'll run this after it completes, but i'm really curious why this is the case
, size/128 as 'size_mb'
,FILEPROPERTY(name, 'SpaceUsed')/128 as'spaceused'
name size_mb spaceused
international 576512 575779
international_log 512 75
international2 576512 575883
international3 576512 575932