摘要
基于SQL Server代理(SQL Server Agent),提出一种实用于地区电网自动电压无功控制(AVC)系统的备份方案,根据地区电网数据库的特点进行分类备份,通过定期清除日志和过期数据文件的方式,有效地解决了地区电网AVC系统日志溢出问题,大大提高数据备份效率,基于FTP协议实现地区电网AVC子站与主站系统之间的备份异地传输,改善了恢复点目标(RPO)和恢复时间目标(RTO),提高了整个AVC系统的容灾能力。基于SQL Server Agent编写了应用程序,在实际地区电网AVC系统的应用证明,该备份方式具有操作简单、成本低的特点,备份效果良好,满足地区电网AVC系统对数据备份与恢复的要求。
A new data backup scheme of automatic voltage control （AVC） system based on SQL Server Agent is proposed. The backup of the databases is carried out based on the features of regional power grid. The problems of log overflowing in AVC system are solved by clearing the logs and the expired data files, which improves the efficiency of data backup. Through the FTP protocol, the off - site transmission between the master station of AVC system and its sub - stations has been realized, tbns RPO and RTO are improved, and the disaster tolerance of the system is increased. This scheme does not use any other made - up backup software, and it is realized by the application program written by SQL Server Agent. The scheme is of simple operation and ）ow cost proved by the trial operation in AVC system of Sichuan Power Grid. Besides, the results of the test prove that this scheme has excellent performance and meets the special requirements of data backup and recovery of AVC system.
出处
《四川电力技术》
2011年第5期14-19,49,共7页
Sichuan Electric Power Technology
