Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Restoring the configuration in InterScan Messaging Security Suite (IMSS) for Windows

    • Updated:
    • 26 Mar 2013
    • Product/Version:
    • InterScan Messaging Security Suite 7.1 Windows
    • Platform:
    • Windows 2000 Advanced Server
    • Windows 2000 Server
    • Windows 2003 Enterprise Server
    • Windows 2003 Standard Server Edition
    • Windows 2008 Enterprise
    • Windows 2008 Standard
Summary
Restore the configuration settings from the administrator database in InterScan Messaging Security Suite (IMSS).
Details
Public
To restore the configuration:
  1. Log on as the database administrator:
    1. If you are using IMSS 7.1 with SQL 2005 or 2008, launch the Microsoft SQL SERVER Management Studio (MSSMS).
    2. Log on as system administrator (SA).
    3. Enter your password.
  2. Execute the following SQL scripts to restore using the imss_bak file:
    Use master
    GO
    RESTORE DATABASE imss_bak FROM DISK =’c:\imss_bak.bak’
    GO
  3. Stop all the IMSS-related services.
  4. Delete the configuration tables in the IMSS database by executing the following SQL scripts:
    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
  5. Copy the configuration tables from the backup database (imss_bak) by executing 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)
    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
    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)
    SELECT * FROM imss_bak..tb_component_list
    GO
    SET IDENTITY_INSERT imss..tb_component_list
    off
    GO
  6. Start all the IMSS-related services.
Premium
Internal
Rating:
Category:
Configure; Migrate
Solution Id:
1035439
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.