SAP DB Reorganization - SQL Server

[Former Member]

Hello gurus,

We would like to perfom a DB reorganization in our system (SQL Server) in order to release space from the system.

Could you please let us know what steps do we need to follow in order to proceed? What is the recommendation to excecute this activity, how often should this be executed?

Thanks and regards,

[sunny_pahuja2 · Accepted solution]

Hi,

Best way to reorganize your database is export/import method. This kind of process is not so frequent. This usually happens when lot of data being archived.

Thanks

Sunny

[Former Member · Accepted solution]

Best way to reorganize your database is export/import method. This kind of process is not so frequent. This usually happens when lot of data being archived.

Hi Sunny,

Could you please provide further details and docummentation for this export/import method?

Thanks,

Best regards

[sunny_pahuja2 · Accepted solution]

Hi,

You can get system copy docs from http://service.sap.com/instguides.

Thanks

Sunny

[markus_doehr2]

> We would like to perfom a DB reorganization in our system (SQL Server) in order to release space from the system.

What kind of "reorganization" are you talking about?

Markus

[Former Member]

Hi Markus,

We are talking about a reorganization at DB level in order to release space from the system.

Best regards,

[JPReyes]

Usually reorganization does not really apply to MSSQL benefits are minimun , are you running out of space in your filesystem?, or do you have too much free space in your DB?... Theres quite a few notes about this have you read them?

Please explain your scenario

Could you please provide further details and docummentation for this export/import method?

This means simply to do a homogeneous system copy

Regards

Juan

[Former Member]

Usually reorganization does not really apply to MSSQL 
benefits are minimun , are you running out of space in your filesystem?, or 
do you have too much free space in your DB?... Theres quite a few 
notes about this have you read them?

Please explain your scenario

Hi

We have some free space in the DB we would like to recover, could you please share us the docummentation so we can analyze it?

Thanks and kind regards.