With DB02 tcode, DB file in red color & status giv...

Former Member · ‎09-23-2008

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 · ‎12-09-2008

HI JP,

SAP Best Practice wants that all your datafiles should be of same size and should have equal amount of free space so that it can grow equally.

Please keep these in mind before change your datafile size.

Regards,

Subhadip

Former Member · ‎11-28-2008

Hello Jigar,

I had the same problem, I found this help file:

It helped me solve my issue, I increased the size of the files as recommended and their status in DB02 changed to green.

Hope this helps you.

Regards,

Chris

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