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

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

BACKUP DATABASE imss_bak TO DIS 'c:\imss_bak.bak'
GO