Remove database errors - Intergraph Smart 3D - Administration & Configuration

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
11 (2016)

In the event of database corruption, use the following guidelines to restore the database to its condition prior to when the corruption occurred.

If your database becomes corrupt, do not perform a full backup. Doing so will destroy your active log file.

  1. Perform an immediate backup of the corrupted database's transaction log.

  2. Attempt to repair the database using consistency checks and other available tools. If the repair attempt fails, follow steps 3 through 5 to restore the database.

    • For information about checking database integrity, see Database Integrity.

    • For detailed information regarding disaster recovery, see the online documentation for Microsoft® SQL Server.

  3. Apply the last full backup.

  4. Apply the last differential backup.

  5. Apply all transaction log backups in succession, from the most recent (after the last differential backup) up to and including the transaction log backup obtained immediately after the database failure.