Procedure

1. Log on as the database administrator:
   1. Open SQL Query Analyzer (for example, SQL 2000 server).
   2. Connect to the database server where the IMSS admin database is installed.
   3. Log on as user “sa”.
2. Create a backup database named imss_bak by running the following SQL script:

   USE master
   GO
   IF EXISTS (SELECT * FROM   master..sysdatabases 
   WHERE  name = 'imss_bak')
   DROP DATABASE imss_bak
   GO
   CREATE DATABASE imss_bak
   GO
   

3. Back up configuration tables to the backup database imss_bak by running the following SQL scripts:

   SELECT * into imss_bak..tb_global_setting 
   FROM imss..tb_global_setting
   SELECT * into imss_bak..tb_named_obj 
   FROM imss..tb_named_obj
   SELECT * into imss_bak..tb_entity 
   FROM imss..tb_entity
   SELECT * into imss_bak..tb_policy 
   FROM imss..tb_policy
   SELECT * into imss_bak..tb_rule 
   FROM imss..tb_rule
   SELECT * into imss_bak..tb_scanning_exceptions 
   FROM imss..tb_scanning_exceptions
   SELECT * into imss_bak..tb_version_number 
   FROM imss..tb_version_number
   SELECT * into imss_bak..tb_entity_rule 
   FROM imss..tb_entity_rule
   SELECT * into imss_bak..tb_named_obj_rule 
   FROM imss..tb_named_obj_rule
   SELECT * into imss_bak..tb_report_tickets 
   FROM imss..tb_report_tickets
   SELECT * into imss_bak..tb_euq_entity 
   FROM imss..tb_euq_entity
   SELECT * into imss_bak..t_foxhuntersetting 
   FROM imss..t_foxhuntersetting
   SELECT * into imss_bak..t_type_setting 
   FROM imss..t_type_setting
   SELECT * into imss_bak..tb_administrator 
   FROM imss..tb_administrator
   SELECT * into imss_bak..tb_inter_addr 
   FROM imss..tb_inter_addr
   SELECT * into imss_bak..tb_named_obj_scan_exception 
   FROM imss..tb_named_obj_scan_exception
   SELECT * into imss_bak..tb_report_setting 
   FROM imss..tb_report_setting
   SELECT * into imss_bak..tb_mta_config 
   FROM imss..tb_mta_config
   SELECT * into imss_bak..t_iprule 
   FROM imss..t_iprule
   SELECT * into imss_bak..t_manual_domain 
   FROM imss..t_manual_domain
   SELECT * into imss_bak..tb_component_list 
   FROM imss..tb_component_list
   GO
   

4. Back up the imss_bak database by running the following SQL script:

   BACKUP DATABASE imss_bak TO DISK= 'c:\imss_bak.bak'
   GO

   Note If you encounter Operating System Error 5, create a folder named backup on disk C where the IMSS admin database is installed and then run the following SQL script: BACKUP DATABASE imss_bak TO DISK= 'c:\backup\imss_bak.bak' GO