Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

With DB02 tcode, DB file in red color & status gives No free space

Hi Experts,

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

FLPRIM X

FILE GROWTH PERCENT X

Kindly reply what action we have to perform to change the file status.

Regards,

JP

Former Member
Not what you were looking for? View more on this topic or Ask a question