Shrinking a Database

Shrink databases, freeing unused space for reuse or deletion.

Note: The shrink database functionality is not supported on the Cluster Edition.
  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. Click the Name field of the database, then click the drop-down arrow and select Shrink.
  4. Select the device from which to release space, or select Add to add a device to the list.
  5. On the Options screen, specify the timeout period for this shrink operation.
  6. On the Summary screen, verify your selections.
  7. Click Finish to perform the shrink operation.