Skip to Content
avatar image
Former Member

Delete Client Client Not Reduce the Database Size

Dear Experts/Gurus.

I have a trouble, and i am new in BASIS,

yesterday i was delete a client ex:820

before delete, my database size is 500GB, but after delete it become 510GB (Maybe because transaction in other client).

How can i reduce the database size when i delete a client ?

Regards,

Aldy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Dec 24, 2014 at 04:43 AM

    Hello  Ri,

    Delete client using T-code---> SCC5 not with SCC4. Then reorg the database.

    Regards

    S.Basis

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 24, 2014 at 05:55 AM

    Hi Ri

    1. Check the transaction code ST04. in Database & log free space?

    2.  You have to perform the MS Sql log truncate backup. then you can check the DB size.

    BR

    SS

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 05, 2015 at 06:45 AM

    have you checked the client has been deleted in SCC4 ? It yes the reorganize the database, check the log file size. And finally take a log truncate backup. then check the DB size again.

    Thanks

    Asad

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 05, 2015 at 09:49 AM

    Note: In most databases, space that has become free is available only after a reorganization.

    (From ADM325 -> Deleting Clients)

    Also, have a look at the below note

    35952 - Client deleted, space still filled in database

    regards,

    pavan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2015 at 06:45 PM

    Hi Ri Zaldy


    What is your database (SQL Server, Oracle etc..) ?


    Reorg database after client deletion, i suggest use this blog Running SAP Applications on Microsoft Platform - Site Home - MSDN Blogs

    -giri

    Add comment
    10|10000 characters needed characters exceeded