Shrinking a Database

Adaptive Server allows you to shrink databases, freeing unused space for reuse or deletion.

1. In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
2. Expand ASE Servers > Schema Objects > Databases, then choose one of:
   • User Databases
   • System Databases
   • Temporary Databases
3. Select a database from the right-hand panel.
4. Click the drop-down arrow and select Shrink. SCC starts the Shrink Database Wizard
5. Select the device from which you will release space, or select Add to add a device to the list.
6. On the Options screen, specify the timeout period for this shrink operation.
7. On the Summary screen, verify your selections.
8. Click Finish to perform the shrink operation.