No free space in file

[former_member1229023]

Hi,

We have SAP ECC running with Sql server 2005.

I was just concerned about below status in DB02

File Name Size Free PCT Next Growth Physical File Name Free Disk Growth Size limit

File Group Status Message

QWDDATA1 32,790 1 0 F:\QWPDATA1\QWPDATA1.mdf 9,589 0MB no limit PRIMARY Less than 5% free space in file

QWDDATA2 29,840 0 0 F:\QWPDATA2\QWPDATA2.ndf 9,589 0MB no limit PRIMARY No free space in file

QWDDATA3 29,840 0 0 F:\QWPDATA3\QWPDATA3.ndf 9,589 0MB no limit PRIMARY No free space in file

QWDDATA4 29,984 23 2,998 R:\QWPDATA4\QWPDATA4.ndf 21,140 10% no limit PRIMARY Autogrow on with enough space to grow

QWDDATA5 29,984 16 2,998 S:\QWPDATA5\QWPDATA5.ndf 21,140 10% no limit PRIMARY Autogrow on with enough space to grow

QWDLOG1 6,195 99 619 L:\QWPLOG1\QWPLOG1.ldf 24,457 10% 2097152 Autogrow on with enough space to grow

1. Status message for 2 secondary files says "No Free space in file" even though there is no size limit on it's growth.

Please advice how can i get rid of these 2 Red indicators. or i should not worry about them, as 4th and 5th file is growing automatically as and when needed?

2. as per my understaing "Secondary files (.ndf) hold data that does not fit in the primary data file (.mdf)" so should I worry about it's status "Less than 5% free space in file" again when there is no size limit on it's growth?

3. Why does the growth shows 0 MB for first 3 files?

4. Which table can be queried to get datafile information at sql server database level?

Please advice!!

-Pranali

[sivakumar_kilari3]

QWDDATA2 29,840 0 0 F:\QWPDATA2\QWPDATA2.ndf 9,589 0MB no limit PRIMARY No free space in file

QWDDATA3 29,840 0 0 F:\QWPDATA3\QWPDATA3.ndf 9,589 0MB no limit PRIMARY No free space in file

Follow the steps.

1. Open SQL Server management studio

2. select your database and right click

3. select properties from the pop up menu

4. Select files option

5. now you can increase in the Initial size column.

Thanks

Siva

[ganesh_borase2]

Hi!

You have to increase the size of the database that shown in red

It will definitely work.

Thanks

Ganesh

[Former Member]

There are administration guides available under please read.