CLient delete space

[Former Member]

Hi,

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

[Former Member]

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

Thanks

N.P.C