Increase the DATAFILE size using Sql Command Editor in SAP

[chandrababu_katta]

The Following steps describes how to increase the DATAFILE size if there is no space left in each file and the status of the each DATAFILE showing RED color in DB02 Transaction

Step1: Check the available space from transaction DB02

Space Overview Screen

Goto Files Tab -> Free Space in Disk

If there is enough space available we can increase the space from the same drive

Also check the existing free space left for each file , If the Exception  Column in Database Files tab showing RED there is no free space left

If its Green there is some space exists

Step 2: If there is no free space and the Exception Column showing RED , We need to increase the space

To do this goto transaction DB02 -> Diagnostics -> SQL Command Editor from SAP

and execute the following command

ALTER DATABASE <SID> MODIFY FILE (NAME = '<SID>DATA2',SIZE = 6144)

Here SIZE in MBs and should be greater than existing files size

Do this for remaining all the DATA Files and make sure the free space should be greater than 10 % overall.

Taking transaction log backup from SAP Gui Using SQL Query from Sql Command Editor

Use the following Query to take Transaction log backup using Sql Command Editor in to a DISK

BACKUP LOG <SID> TO DISK = ‘D:\<FILENAME>.TRN

Thanks,

Chandrababu