Log In    |    Knowledge Base    |    4D Home
Tech Tip: How to repair a structure or data file using 4D Server
PRODUCT: 4D Server | VERSION: 11.4 | PLATFORM: Mac & Win
Published On: May 21, 2009
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

Is it possible to repair a structure or data file using only 4D Server? Or do you need 4D?

The answer is yes, you can do it using only 4D Server. You do not need 4D if you only have 4D Server. Follow these steps:

  1. Quit 4D Server if it's running.
  2. From the File Menu select Open...
  3. Click on your database.
  4. From the Open drop-down menu (Mac) or the Open button (Windows),
    select Maintenance & Security Center.
  5. Click Open to open your structure.
  6. The Maintenance and Security Center will be available with all the options.
    You can check and/or repair your Data and Structure.

You can find more information about the Maintenance and Security Center, in Chapter 25 of the 4D v11 SQL Design Reference. You can download it at:

Commented by Timothy Penner on June 11, 2009 at 11:59 AM
When repairing a structure or data file it is normally best practice to Open the MSC window without first opening your database; then, from the MSC window, you can choose which database to open. Doing this will prevent any startup code from running in your database.
Commented by Luis on May 29, 2009 at 3:21 PM
You can also access the Maintenance and Security Center from the Help menu. Once selected, a dialog will allow you to open your database.