Manage Databases

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

• Creating a User Database
  Create a user database using the Administration Console of Sybase Control Center.
• Creating a Temporary Database
  Create a temporary database using the Administration Console of Sybase Control Center.
• Creating a Proxy Database
  Create a proxy database using the Administration Console of Sybase Control Center.
• Creating an Archive Database
  Create an archive database using the Administration Console of Sybase Control Center.
• Creating an In-Memory Database
  Create an in-memory database using the Administration Console of Sybase Control Center.
• Creating an In-Memory Temporary Database
  Create an in-memory temporary database using the Administration Console of Sybase Control Center.
• Creating a Temporary Database Group
  Create a temporary database group using the Administration Console of Sybase Control Center.
• Backing Up Databases
  Sybase Control Center helps you back up a database and its transaction log.
• Restoring Databases
  Sybase Control Center helps you restore a database backup and its transaction log.
• Viewing Database Statistics
  Sybase Control Center obtains database statistics by executing the Adaptive Server optdiag utility.
• Checkpointing Databases
  Use the checkpoint command to force Adaptive Server 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 Adaptive Server Database
  Mount a user database on an Adaptive Server.
• Unmounting an Adaptive Server database
  Unmount a database from an Adaptive Server.
• Database Properties
  Use the database Properties wizard to modify database options, cache options and storage allocation, extend log buffers, and change the owner.
• Deleting a Database Object
  Sybase Control Center helps you delete database objects, or the database itself.
• Generating a DDL Script
  Use Sybase Control Center to generate DDL to create a database or any of its objects.