| 基于SQL Server代理的地区电网AVC系统数据备份 |
| |
| 引用本文： | 白天宇,肖先勇. 基于SQL Server代理的地区电网AVC系统数据备份[J]. 四川电力技术, 2011, 34(5): 14-19,49 |
| |
| 作者姓名： | 白天宇 肖先勇 |
| |
| 作者单位： | 四川大学电气信息学院,四川成都,610065 |
| |
| 摘 要： | 基于SQLServer代理（SQLServerAgent），提出一种实用于地区电网自动电压无功控制（AVC）系统的备份方案。根据地区电网数据库的特点进行分类备份，通过定期清除日志和过期数据文件的方式，有效地解决了地区电网AVC系统目志溢出问题，太大提高数据备份效率，基于FTP协议实现地区电网AVC子站与主站系统之间的备份异地传榆，改善了恢复点薛标（RPO）和恢复时间目标（RTO），提高了整个AVC系统的容灾能力。基于SQLServerAgent编写了应用程序，在实际地区电网AVC系统的应用证明，该备份方式具有操作简单、成本低的特点，备份效果良好，满足地区电网AVC系统对数据备份与恢复的要求。
|
| 关 键 词： | SQL Server代理 地区电网 AVC系统 数据备份 RPO RTO 数据恢复 |
Data Backup Scheme for AVC System in Regional Power Grid Based on SQL Server Agent |
| |
| Bai Tianyu Xiao Xianyong. Data Backup Scheme for AVC System in Regional Power Grid Based on SQL Server Agent[J]. Sichuan Electric Power Technology, 2011, 34(5): 14-19,49 |
| |
| Authors: | Bai Tianyu Xiao Xianyong |
| |
| Affiliation: | Bai Tianyu Xiao Xianyong |
| |
| Abstract: | 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,thus RPO and RTO are improved,and the d... |
| |
| Keywords: | SQL Server Agent regional power grid automatic voltage control system data backup RPO RTO data recovery |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
