Skip to Content
author's profile photo Former Member
Former Member

CLient delete space


We are using ECC6.0 , MS SQL2005 64bit database.

We are almost doing production go-live activities. During this process we have created new client in production 600 and did local client copy SAP_CUST from original client 500. After that we have deleted original client using SCC5.

Even we have deleted the original client 500 we still see the space utilization.

After delete the client usng SCC5 how to get the free space.Do i need to reorganize the dataabase?

What all post steps i have to do after deleting the client.

- Kristsne

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 10, 2007 at 11:02 AM

    Hello Kristene,

    Unless you have an urgent requirement to reclaim the space I recommend you do not do a DB Shrink or a Reorg. A DB shrink will lead to serious performance problems and a Reorg will at best make a tiny improvement.

    SQL Server will reuse the space as data is added to the production system.

    My specific advice is leave the unallocated space as it is unless there is a very strong reason for reclaiming the space (there are ways to do this).

    Review Note 159316 - Reorganizing tables on SQL Server SQL 20002005



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.