How can I set up and maintain the database? Parent topic

The following commands can help you maintain the database:

Procedure

  1. Backup the configuration tables.
    1. Log on as database administrator.
      1. Open SQL Query Analyzer.
      2. Log on as sa.
    2. Back up the IMSS database as follows:
      BACKUP DATABASE imss TO DISK=’c:\imss.bak’
      GO
      
  2. Restore the configuration tables.
    1. Log on as database administrator.
      1. Open SQL Query Analyzer.
      2. Log on as sa.
    2. Restore the IMSS database as follows:
      Use masterGO
      RESTORE DATABASE imss FROM DISK=’:\imss.bak’
      GO