I tried to enlarge a database size of database instance on my SQL Server 2012.
I manually added a new .MDF
file under database instance
After restart on shrink database dialog I can see available space
on shrink files dialog the available free space is added
but when I executed following SQL query the available space still small
select
name
, filename
, convert(decimal(12,2),round(a.size/128.000,2)) as FileSizeMB
, convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)) as SpaceUsedMB
, convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) as FreeSpaceMB
from
dbo.sysfiles a
The database still see only two files ....
What I did wrong ?
[Edit] If just statistics shown wrong in query, it's OK for me. My question is the whole process to add space to the database made in the right way or I need to add something to finish the process? Sorry for editing later
Thanks for any help