Database recovery is a maintenance task performed as part of regular operations. For more information about when to recover a database, see 5.2.2(3) Recovering the database (Microsoft SQL Server) in the manual Administrator's Guide Volume 2.

This option is disabled if Oracle was selected during server installation.

Notes

• If you are using Asset Information Manager Subset, stop the Asset Information Manager Subset services in the following order.
  

  World Wide Web Publishing Service or World Wide Web Publishing Commands and tasks of the Asset Information Synchronous Service and Asset Information Manager Subset JP1/Client Security Control - Manager (applicable if JP1/CSC is linked)

  To use Asset Information Manager Subset after you have used the Database Manager, start the services in the reverse order from that listed above.
  
• If a connection pool has been set up in the ODBC database, the connected status will not change from the time that the Asset Information Manager Subset job was stopped until the timeout time set in the connection pool elapses. Therefore, wait for the connected status to change before recovering the database.

To recover a relational database:

1. In the Welcome dialog box, choose Relational database system to be used, Recover database, and then click the Next button.
   The Select Database dialog box appears.
   
2. Specify the server, database name, administrator ID, and password for the database to be recovered, and click the Next button.
   The Recover Database dialog box appears.
   

   Figure 7-42 Recover Database dialog box

   

   The dialog box displays a list of tables to be repaired. Select the check boxes of the tables to be repaired. If you select all tables, the system searches the entire relational database and repairs all table inconsistencies.
   
   • Software package table
     This option recovers the table related to packages.
     
   • Job execution management table
     This option recovers the table related to job execution.
     
   • Job definition management table
     This option recovers the table related to job definitions.
     
3. Click the Execute button.
   The system repairs the selected tables and recovers the relational database.