Using Mssql 2005 we see is available the "SQL Server Integration
Services (SSIS)" tools from Microsoft.
It allows actions like 'Reorganize DB and Indexes' and skrinkdatabase.
We would like to know if these actions can be executed on a MsSql
running a Sap System, in ordert to make some space free, and if there
are controindications from the Sap point of view.
More in general, we wonder of the existence of these commands; we
always understand MsSql does not need to be reorganized as Oracle in
case of mass deletion of data (obsolete clients, sap data
archiving ,...).
In case there is not mass deletion of data wich can be the expected
result of the execution of the reorganization of data and indexes with
MsSql using these tools ?
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.