increase free space in data files

[Former Member]

Hello All,

We are running netweaver 04s on sql server. In our EPR landscape, we are having message no free space in file in db02 transaction. It reports error when we execute DB02 and does not allows or shows us the DBCC check options. Strangely, this message appears even if the auto grow option in data files is on.

Could you please let me know what would be the impact if I increase the datafiles initial size?

Thanks,

Gaurav

[Former Member]

There is no negative impact in increasing the datafiles size. It might slow down your system while it expands so plan on doing it on off hours, but other then that you are just creating empty space. We often increase our datafiles manually to avoid autogrowth during business hours and have never had an issue.

[Former Member]

Hello Jeff,

Thanks for the response!

The odd thing out is that, we do have autogrowth on, and I am sure the data file size is getting increased on all the datafiles, otherwise the database would have struck up but the information that we get on DB02 transaction is wrong or the correct information is not bieng reflected.

Also, I am not able to run the DBCC checks via dbacockpit!

Please share your thoughts!

Thanks,

Gaurav

[Former Member]

if you have MS SQL you can run it from the SQL prompt:

for example the query analyzer

this is the code

dbcc checkdb(SID)with no_infomsgs

Good Luck

Joris

[Former Member]

What is the Support Package level. If it is above SP12 try DB02OLD.

Check Note 738979 - In DB02 -> Space statistics, Size/kb = 0 for some tables