Summary
Create a backup of the configuration settings on InterScan Messaging Security Suite (IMSS) through the administrator database.
Details
To create a backup:
- Log on as the database administrator:
- If using IMSS 7.1 with SQL 2005 or 2008, launch the Microsoft SQL SERVER Management Studio (MSSMS).
- Connect to the database server where the IMSS administrator database is installed.
- Log on as a user.
- 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 - 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 - Back up the imss_bak database by executing the following SQL scripts:
BACKUP DATABASE imss_bak TO DIS 'c:\imss_bak.bak'
GO