Procedure

1. Log on as database administrator:
   1. Open an SQL Query Analyzer.
   2. Log on as sa.
2. Restore the imss_bak file by executing the following SQL script:

   Use master
   GO
   RESTORE DATABASE imss_bak FROM DISK = 'c:\imss_bak.bak'
   GO
   

3. Stop all IMSS related services.
4. Delete the configuration tables in the IMSS database by running the following SQL script:

   USE imss
   GO
   DELETE FROM tb_global_setting 
   DELETE FROM tb_component_list 
   DELETE FROM t_manual_domain 
   DELETE FROM t_iprule 
   DELETE FROM tb_mta_config 
   DELETE FROM tb_report_setting 
   DELETE FROM tb_named_obj_scan_exception 
   DELETE FROM tb_inter_addr   
   DELETE FROM tb_administrator 
   DELETE FROM t_type_setting 
   DELETE FROM t_foxhuntersetting 
   DELETE FROM tb_euq_entity 
   DELETE FROM tb_report_tickets 
   DELETE FROM tb_named_obj_rule 
   DELETE FROM tb_entity_rule  
   DELETE FROM tb_version_number  
   DELETE FROM tb_scanning_exceptions 
   DELETE FROM tb_rule 
   DELETE FROM tb_policy 
   DELETE FROM tb_entity 
   DELETE FROM tb_named_obj 
   GO
   

5. Copy configuration tables from the backup database imss_bak by running the following SQL scripts:

   INSERT INTO imss..tb_global_setting
   SELECT * 
   FROM imss_bak..tb_global_setting 
   GO 
   SET IDENTITY_INSERT imss..tb_named_obj on
   GO   
   INSERT INTO imss..tb_named_obj(id,type,name,
   content,msg_count,msg_size ) 
   SELECT * FROM imss_bak..tb_named_obj
   GO   
   SET IDENTITY_INSERT imss..tb_named_obj off
   GO 		                         
   SET IDENTITY_INSERT imss..tb_entity on
   GO
   INSERT INTO imss..tb_entity(entity_id,entity_type,
   entity_name, root_entity) 
   SELECT * FROM imss_bak..tb_entity  
   SET IDENTITY_INSERT imss..tb_entity off
   GO
   SET IDENTITY_INSERT imss..tb_policy on
   GO	 	                                  
   INSERT INTO imss..tb_policy
   (policy_id,policy_name,policy_type,is_enable,
   is_default,is_hidden,create_by,modify_by,
   creation_time,last_modified_time) 
   SELECT * FROM imss_bak..tb_policy    
   GO 
   SET IDENTITY_INSERT imss..tb_policy off
   GO
   SET IDENTITY_INSERT imss..tb_rule on
   GO     
   INSERT INTO imss..tb_rule( rule_id, policy_id,
   version_number, rule_name, active_time, rule_type,
   display_action, has_multi_actions,
   has_virus_filter, has_spam_filter,
   has_attachment_filter, has_content_filter,
   has_size_filter, has_time_range_filter,
   has_other_filter, note, rule_value, rule_order,
   has_wrs_filter)
   SELECT * FROM imss_bak..tb_rule
   GO
   SET IDENTITY_INSERT imss..tb_rule off
   GO                             
   INSERT INTO imss..tb_scanning_exceptions 
   SELECT * FROM imss_bak..tb_scanning_exceptions 
   GO                  
   INSERT INTO imss..tb_version_number 
   SELECT * FROM imss_bak..tb_version_number    
   GO                    
   INSERT INTO imss..tb_entity_rule 
   SELECT * FROM imss_bak..tb_entity_rule 
   GO
   INSERT INTO imss..tb_named_obj_rule 
   SELECT * FROM imss_bak..tb_named_obj_rule 
   GO 
   SET IDENTITY_INSERT imss..tb_report_tickets on
   GO                          
   INSERT INTO imss..tb_report_tickets( ticket_id,
   admin_id, report_type, request_timestamp,
   report_name, report_status, scanner_name,
   report_item, report_start_day, reset_column,
   time_start, time_end, run_today, isenabled )
   SELECT * FROM imss_bak..tb_report_tickets 
   SET IDENTITY_INSERT imss..tb_report_tickets off
   GO
   SET IDENTITY_INSERT imss..tb_euq_entity on
   GO                           
   INSERT INTO imss..tb_euq_entity(entity_id,entity_name)
   SELECT * FROM imss_bak..tb_euq_entity     
   GO
   	SET IDENTITY_INSERT imss..tb_euq_entity off
   GO                            
   INSERT INTO imss..t_foxhuntersetting 
   SELECT * FROM imss_bak..t_foxhuntersetting 
   INSERT INTO imss..t_type_setting 
   SELECT * FROM imss_bak..t_type_setting
   SET IDENTITY_INSERT imss..tb_administrator on
   GO                               
   INSERT INTO imss..tb_administrator( admin_id,
   admin_name, enabled, using_imss_auth,
   own_root_entity, md5_digest, summary_permission,
   policy_permission, ipfiltering_permission,
   reports_permission, logs_permission,
   quarantines_permission, system_permission )
   SELECT * FROM imss_bak..tb_administrator
   GO                         
   SET IDENTITY_INSERT imss..tb_administrator off
   GO    		
   INSERT INTO imss..tb_inter_addr 
   SELECT * FROM imss_bak..tb_inter_addr  
   GO                          
   INSERT INTO imss..tb_named_obj_scan_exception 
   SELECT * FROM imss_bak..tb_named_obj_scan_exception 
   GO
   INSERT INTO imss..tb_report_setting 
   SELECT * FROM imss_bak..tb_report_setting 
   GO 
   INSERT INTO imss..tb_mta_config 
   SELECT * FROM imss_bak..tb_mta_config 
   GO
   INSERT INTO imss..t_iprule 
   SELECT * FROM imss_bak..t_iprule 
   GO
   INSERT INTO imss..t_manual_domain 
   SELECT * FROM imss_bak..t_manual_domain 
   GO		
   SET IDENTITY_INSERT imss..tb_component_list on
   GO	
   INSERT INTO imss..tb_component_list( scanner_id,
   scanner_name, ip_addr, daemon, policy, euq, nrs,
   ipprofiler, euq_port, admin_cmd, app_ver) 
   SELECT * FROM imss_bak..tb_component_list 	
   GO 		
   SET IDENTITY_INSERT imss..tb_component_list off
   GO	
   

6. Start all IMSS 7.5 services.