Skip to Content
0
Former Member
May 22, 2009 at 01:59 PM

MSSQL server datafile size increase

795 Views

Hi Gurus,

I am new to SAP with MSSQL server. Our ECC6.0 production server is running with MSSQL server.

In db02, the indicator is in red colour and below is the status.

Intial size of datafile1 is 27.010 GB and actual mdf size in disk at present is 26.5 GB.

In db02, it is showing free space - 0.00 and Next growth 150 MB. (Indicator - Red colour)

My customer want to make this Green. Please let me know what should I do now.

Shall I increase the Initial size of datafile online when SAP is up and running to 10% more?

Will it be a permanent solution or should I need to increase the size of Next growth also?

Regards,

Nalla.