With DB02 tcode, DB file in red color & status gives No free space
With DB02 transaction --> in File tab it is showing all Database files with red color and in the status message gives "No free space in file".
Below is details for your reference
Logical file name used by SQL Server: DEVDATA1
File size in MB: 30.220
SQL Server FILE ID 1
Next file growth(MB) 3.022
Physical file name of the database file E:\DEV\SAPDATA\DEVDATA1\DEVDATA1.mdf
Allocated MB 30.167
Free on file system (MB) 86.284
Growth Setting 10%
File size limit in MB no limit
Filegroup name PRIMARY
Status Message No free space in file
FILE GROWTH PERCENT X
Kindly reply what action we have to perform to change the file status.