校园网数据库服务器数据备份与恢复

Data Backup and Restore of Database Server in Campus Network

校园网中应用到多种数据库管理系统,学校的各种重要数据存储在数据库中。这些数据不能出现丢失、损坏等灾难问题。鉴于校园网数据的重要性和DBMS的多样性,文中结合实际应用和相应数据库管理系统提供的数据备份与恢复功能,给出了Oracle、SQL Server、MySQL、SQLite等常用数据库系统的数据备份与恢复的策略和方法,经实际应用,效果良好。

A variety of database management systems are applied in the campus network, with the im- portant data stored in the database. Any problem should not arise such as loss or damage of the data. In view of the significance of data and diversity of DBMS, combining with the application as well as data backup and restore provided by associated database management systems, this paper presents the strate- gies and methods of data backup and restore of most commonly-used database systems, such as Oracle, SQL Server, MySQL and SQLite. It works well in practical application.