DB02

[Former Member]

Hi,

When i execute DB02 it is showing below values:

Database

DB size (MB) 59.880

Size used (MB) 59.798

Free (MB) 82

then how can i increase the DB Size?

can any body please give me the step by step procedure ASAP.

awaiting for your Reply.

Vinnu.

[clas_hortien]

Hello,

you can do this in two ways:

1) Running a script like

ALTER DATABASE <YourDBName> MODIFY FILE (NAME='<SID>DATA1',

SiZE=<NewSize with SizeSpecifier like 25GB>)

See books online for the exact syntax. You have to modify each file separetly.

2) Using the Enterprise Manager or Development Studio. Open the Properties of

the DB and switch to the files view. Enter a new Size for each file and apply

the changes.

Best regards

Clas

[markus_doehr2]

Use brspace (in case you use Oracle) on command line.

--

Markus

[Former Member]

Sorry this is MSSQL.

[markus_doehr2]

Check

<a href="http://help.sap.com/saphelp_nw70/helpdata/en/f2/31ad8f810c11d288ec0000e8200722/frameset.htm">http://help.sap.com/saphelp_nw70/helpdata/en/f2/31ad8f810c11d288ec0000e8200722/frameset.htm</a>

--

Markus