Database file size status is coming RED

[Former Member]

Hi Experts,

all 3 database files status is coming in RED in Tcode DB02. How can Iincrease the file sizes.

can you please explain step by step

Thanks a lot in advance

NG

[Former Member]

Nidhi,

All 3 database files status is coming in RED in Tcode DB02

.

It seems your DB is MS SQL.What is your database ?

How can increase the file sizes.

If your question is How to increase datafile size in MS SQL then chek below link.

Hope this helps

Thanks

Sushil

[anindya_bose]

Hi Nidhi

I suppose by now you have got the answerto your question. If not use brtools from operating system level. Its quite simple and self explanatory..

Please check the link below

http://help.sap.com/saphelp_nw70/helpdata/en/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm

Below are the steps, please check properly when you use BRTOOLS.There may be little difference in message Brtools shows

1.Analyze what tablespace should be extent, please check the available space

carefully before decide to extent table space

2.Go to server login with adm

3.Run brtools

4.Go to space management (option number 2)

5.Go to extend tablespace (option number 1)

6.Check the option, if itu2019s ok wih the default setting type c then enter to

continue to next brspace process

7.Go to extend tablespace (option number 1)

8.All tablespaces will be appeared enter to scroll down choose the tablespace which will be extended

9.Mandatory option to be checked is option number 3 (New file to be added (file))

use to locate where new datafile will be created

10.Also check option number 5 (Size of the new file in MB (size) make sure

destination is enough to create new datafile

11.Continue

12.When system ask to add next data file automatically please donu2019t choose yes

chose no / continue to continuing the process

on normal condition next datafiles should be defined one by one

13.Donu2019t forget to choose exit after finish

Thanks and Regards

Anindya

[Former Member]

Hi

What is your database ?

Regards

Uday

[Former Member]

Hi Nidhi ,

Please let me know your Database .

Is there any space available in your Hard disk ? If space is available , please go to SQL Management l STUDIO in SQL 2005 or EnterPrise

manager in case of SQL 2000 > Database > Select the database > Properties > Files > INcrease the Initial Size according to

your space in Hard Disk.

This will make your DB02 Green.

Please let me know if you feel any difficulty.

Regards,

Nibu Antony

Edited by: Nibu Antony on Jun 29, 2009 12:43 PM