Procedure documentationInitializing Databases Locate this document in the navigation structure

 

When you initialize a database, you delete all data (including the application data and database catalog) and all log entries from the volumes. The configuration of the database (database parameters, volume definitions, and so on) is retained, however.

Initializing a database is required in special recovery situations, for example.

Prerequisites

  • You are logged on to the database as database system administrator or as a DBM operator with server authorization for accessing utility sessions.

    More information: Glossary, Server Permission

  • For a database on the local computer, you require administration authorizations for the computer as an operating system user.

    For a database on a remote computer, you must be logged on to the remote computer as an operating system user with the following authorizations: administration authorizations and on Microsoft Windows additionally the Log on as batch job authorization. For more information, see your operating system documentation.

  • The database is in the ADMIN operational state.

Procedure

This function has not been implemented in Database Studio yet. Use the corresponding DBM command instead.

More information:

More Information

Restoring Databases