The restore database operation removes all applied and unapplied schema modifications, and resets the current Relational Design Center session back to a schema that matches the current Enterprise Database Server database. The MCP server SQL catalog is also restored to a state that matches the current Enterprise Database Server database.
-
The restore database operation is available only to an Enterprise Database Server database and only after the database is opened. The restore database operation is not available to SQL schema-generated databases.
-
Exercise caution when using the restore database operation as it removes all views and field changes that were already applied and unapplied.
Perform the following steps to restore a database in the tree view:
-
From the tree view, right-click the database you want to restore, and click Restore Database.
The Restore Database Status dialog box appears indicating that a restore operation was performed.
-
Click OK.
