Manage Databases

From the Perspective Resources view, use the Administration Console option to create databases, modify their properties, and perform other administrative tasks.

• Creating a User Database
  Create a user database using the SAP Control Center Administration Console.
• Creating a Proxy Database
  Create a proxy database using the SAP Control Center Administration Console.
• Creating a Temporary Database
  Create a temporary database using the SAP Control Center Administration Console.
• Creating an Archive Database
  Create an archive database using the SAP Control Center Administration Console.
• Creating an In-Memory Database
  Create an in-memory database using the SAP Control Center Administration Console.
• Creating an In-Memory Temporary Database
  Create an in-memory temporary database using the SAP Control Center Administration Console.
• Creating an Encrypted Database
  Manage the transparent encryption of databases through SAP Control Center.
• Creating a Temporary Database Group
  Create a temporary database group using the SAP Control Center Administration Console.
• Shrinking a Database
  Shrink databases, freeing unused space for reuse or deletion.
• Backing Up (Dumping) a Database
  Use SAP Control Center to help you back up a database and its transaction log.
• Scheduling a Database Backup
  Use SAP Control Center to schedule backups of databases.
• Restoring (Loading) a Database
  Restore a database backup and its transaction log.
• Viewing Database Statistics
  View database statistic using SAP Control Center.
• Checkpointing Databases
  Use the checkpoint command to force SAP ASE to write modified data pages from memory to disk.
• Checking Database Consistency
  Use the database consistency check to check the logical and physical consistency of a database.
• Placing a Database in Quiesce-Hold
  Use Quiesce Hold to block updates to a database during a copy operation.
• Placing a Database in Quiesce-Release
  Use quiesce release to resume database updates that were suspended by a quiesce hold command.
• Mounting an SAP ASE Database
  Mount a user database on a server.
• Unmounting an SAP ASE Database
  Unmount a database from a server.
• Database Properties
  Use the Database Properties window to modify database options, cache options and storage allocation, extend log buffers, and change the owner.
• Generating DDL for a Database
  Use SAP Control Center to generate a DDL script for databases.
• Deleting a Database
  SAP Control Center helps you delete database objects, or the database itself.