Show TOC

Procedure documentationErasing the Databases

Procedure

If the database validation fails, meaning that part of the database is corrupt, you must take action to mend or replace the corrupt database. The simplest solution occurs when a store has a corrupt database but performs daily backups. In this case, the current corrupt database can be erased, and the backup from the previous day reloaded.

To erase a database:

  1. Using SQL Central, click on the Utilities folder in the left portion of the window to display a list of SQL utilities in the right portion.

  2. In the SQL Central right pane, double-click Erase Database.

  3. On the next dialog box you must specify the full path and name of the database you wish to erase.

  4. Click Next.

  5. The second dialog box within the ‘Erase’ utility asks which components of the selected database you wish to erase.

    • Click the top check box if you wish to erase the data, structure and write files of the selected database.

    • Click the lower check box if you wish to erase the database’s log file.

  6. Click Next.

  7. The final dialog box displays information regarding the files to be erased.

  8. Click Finish.