Figure 27-8: unmount database command
WARNING! The unmount command removes a database and all its information from the Adaptive Server. Use the unmount command with extreme caution.
When you unmount a database, you remove the database and its devices from an Adaptive Server. The unmount command shuts down the database and drops it from the Adaptive Server. The devices are also deactivated and dropped. The database and its pages are not altered when they are unmounted. The database pages will still be present on the OS devices.
unmount database <dbname list> to <manifest_file>
Use quiesce database to create the manifest file, then execute unmount. For example:
1> unmount database pubs2 to "/work2/Devices/Mpubs2_file" 2> go
If you now try to use the pubs2 database you see this error:
Attempt to locate entry in sysdatabases for database 'pubs2' by name failed - no entry found under that name. Make sure that name is entered properly.
