摘要
基于触发器技术的SQL Server数据库实时备份方案使用双机备份方式,根据触发器自动执行数据备份的代码和关系数据库存储数据变化前后的状态检索、数据变化痕迹,可以快捷地实现数据恢复,具有很强的实时性和直观性。
SQL Server database real-time backup based on the trigger techniques is double sever backup method. Database automatically backup by running the special procedure deployed in the trigger and realizes database recovery rapidly according to the data states and the modification tracks stored in relation tables. It is shown that the proposed solution is real-time and intuitive.
出处
《广西科学院学报》
2009年第3期210-212,共3页
Journal of Guangxi Academy of Sciences
基金
广西社科基金项目(06FTQ002)资助
关键词
数据库
备份
触发器
database, backup, trigger