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

Create a technical support case if you need further support.

Backing up the configuration settings in InterScan Messaging Security Suite (IMSS)

    • 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
Create a backup of the configuration settings on InterScan Messaging Security Suite (IMSS) through the administrator database.
Details
Public
To create a backup:
  1. Log on as the database administrator:
    1. If using IMSS 7.1 with SQL 2005 or 2008, launch the Microsoft SQL SERVER Management Studio (MSSMS).
    2. Connect to the database server where the IMSS administrator database is installed.
    3. Log on as a user.
  2. Create a backup database, imss_bak, by executing the following SQL scripts:
    USE master
    GO
    IF EXISTS (SELECT * FROM master..sysdatabases WHERE name = 'imss_bak')
    DROP DATABASE imss_bak
    GO
    CREATE DATABASE imss_bak
    GO
  3. Execute the following SQL scripts to back up the configuration tables to the imss_bak database:
    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
  4. Back up the imss_bak database by executing the following SQL scripts:
    BACKUP DATABASE imss_bak TO DIS 'c:\imss_bak.bak'
    GO
Premium
Internal
Rating:
Category:
Configure; Migrate
Solution Id:
1035438
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.