Skip to Content
Author's profile photo chandrababu katta

Increase the DATAFILE size using Sql Command Editor in SAP

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


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





Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.