基于SQLSever播出数据库的高安全部署方案

High-Security Deployment Scheme Based on SQL Sever Broadcast Database

贵州广播电视台的播出数据库存储了所有的播出数据,包括素材信息、操作日志信息以及人员管理信息等。播出数据库的安全保障尤为重要。介绍一种基于SQL Sever播出数据库的高安全部署方案。方案采用主备数据库集群的架构,结合异地备份的方式,将数据备份和日志备份操作错开时间点进行。这种备份方式在减小数据库服务器压力的同时提供了更高的还原精度,在保障播出数据安全方面具有一定的应用价值。

The broadcast database of Guizhou radio and television station stores all the broadcast data,including material information,operation log information and personnel management information.The security of broadcast database is particularly important.This paper introduces a high security deployment scheme based on SQL Sever broadcast database.In this scheme,data backup and log backup are staggered at different time points based on the architecture of active and standby database clusters and remote backup.This backup method not only reduces the pressure of database server,but also provides higher restoration accuracy,and has certain application value in ensuring the security of broadcast data.