| SQL Server数据库的自动化远程备份 |
| |
| 引用本文： | 于泽德. SQL Server数据库的自动化远程备份[J]. 实验科学与技术, 2008, 6(5): 71-73 |
| |
| 作者姓名： | 于泽德 |
| |
| 作者单位： | 内江师范学院计划财务处,四川,内江,641112 |
| |
| 摘 要： | 数据库备份是数据库安全的重要保证。以天财财务管理系统的后台SQL Server数据库为例,确定每天对当前账务和收费数据库进行2次自动远程备份的策略。进而提出先利用SQL Server的数据库维护计划功能将数据库备份到服务器,再利用文件同步软件Second Copy将备份文件复制到客户端计算机,并使两者的备份数据同步。
|
| 关 键 词： | SQL Server数据库 自动备份 文件同步 |
Automatic Remote Backup of SQL Server Database |
| |
| YU Ze-de. Automatic Remote Backup of SQL Server Database[J]. Experiment Science & Technology, 2008, 6(5): 71-73 |
| |
| Authors: | YU Ze-de |
| |
| Affiliation: | YU Ze-de ( Department of Financial Affairs, Neijiang Normal University, Neijiang 641112, China) |
| |
| Abstract: | Database backup is an important guarantee of database security. Taking SQL Server database for the background of Tiancai'financial management system as an example,this paper proposes an automatic remote database backup strategy for the current accounts and charges database, twice daily. To backup database to the Server using the SQL Server database maintenance plan features,and copy the backup files to the client using file by synchronization software Second Copy,hence securing synchronous backup data of both the server and the Client. |
| |
| Keywords: | SQL server database automatic backup file synchronization |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
