Refit

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

DBArtisan lets you refit a database device. If you are restoring a damaged master database, or have added devices since the last database or transaction log dump, then refit a device after reinitializing. Refitting a device ensures that the information in sysusages and sysdatabases is consistent with the information in sysdevices.

Platform Availability

To Refit a Database Device

  1. Initiate a Refit action against one or more database devices. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the Refit wizard:
Step Settings and tasks

Action options

Displays the database devices you selected for refitting.

Dependencies

Review the referring and referred objects that will be automatically resolved when you execute this operation.

Preview

Preview the DDL generated for the operation.

3. Click Execute. For information on the scheduling option, see Scheduling.