Shuts down the database and drops it from the SAP ASE server. The devices are also deactivated and dropped.

The database and its pages are not altered when they are unmounted. The database pages remain on the OS devices. Once the unmount command completes, you can disconnect and move the devices at the source SAP ASE server if necessary. Use the manifest_file extension to create the manifest file for use at the secondary SAP ASE server.

The unmount command limits the number of databases to eight in a single command.

Warning!  The unmount command removes a database and all its information from the SAP ASE server. Use the unmount command only when you want to remove the database from one SAP ASE server to another SAP ASE server.


unmount database dbname_list to manifest_file




Unmount a database if sp_configure "disable disk mirroring" is set to off.

You cannot:
  • Unmount system databases. However, you can unmount sybsystemprocs.

  • Unmount proxy databases or user created temporary databases.

  • Use the unmount command in a transaction.

  • Unmount a database on an HA-configured server.

In the Cluster Edition, mount database and unmount database are supported in the Cluster Edition. If an instance fails while one of these commands is in progress, the command may abort. In this case, the user must re-issue mount database or unmount database when the instance failover recovery is complete.

When using encrypted columns with unmount database:
  • When columns are encrypted by keys from other databases, unmount all related databases as a set. The interdependency of the databases containing the encrypted columns and the databases containing the keys is similar to the interdependency of databases that use referential integrity.

  • Use the override option to unmount a database containing columns encrypted by a key in another database (the SAP ASE server issues a warning message, but the operation is successful).

  • If you do not include with override, commands fail with an error message

These commands fail with an error message without the override:
unmount database key_db
unmount database col_db


ANSI SQL – Compliance level: Entry-level compliant.


The permission checks for unmount differ based on your granular permissions settings.


With granular permissions enabled, you must be a user with unmount any database privilege.


With granular permissions disabled, you must be a use with sa_role.


Values in event and extrainfo columns of sysaudits are:



Audit option


Command or access audited

unmount database

Information in extrainfo
  • Roles – current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – NULL

  • Proxy information – original login name, if a set proxy is in effect

Related reference
quiesce database