基于SQLDMO的数据库备份与恢复的实现

The Implementation to Backup and Restore the Database Based on SQLDMO

介绍了数据库备份与恢复的基本方法,特别是封装数据库操作的作用.以SQL Server2000为例,在ASP.NET(C#语言)环境下实现了基于SQLDMO的数据库备份和还原.分析了备份和还原的几种方法、选择策略和SQLDMO的功能.详细给出了备份和还原的具体思路和类实现,存储过程和游标在还原中的应用.

In this article, we introduce the basic methods to backup and restore the database, especially, the function of encapsulating operations provided by database. SQL Server2000 is taken as an example to show how to backup and restore the database based on SQLDMO in C # , which is one of the languages supported by ASP. NET. We anglicize several methods to backup and restore database, the strategies to choose them, and the functions of SQLDMO. Finally, the detailed idea and class implementation to backup and restore database as well as the application of stored procedure and cursor in restoring database are given.