SQL Server数据库备份与恢复技术的分析与实践

Analysis and Practice of SQL Server Database Backup and Recovery Technology

数据库备份与还原是数据库维护的重要环节，是保证数据完整、正确，防止数据丢失的重要手段。在应用系统的维护中，数据库的备份与恢复是数据库管理员（DBA）经常要面对的问题。就SQL SERVER数据库备份与恢复的技术与方法进行探讨，并对一些实例进行分析。

Database backup and recovery is an important link of database maintenance, and is a significant means for complete and correct data with data loss prevention. In maintaining an application system, the backup and recovery of database shall be a frequent issue to a database administrator （DBA）. This article aims to discuss on technology and approach of SQL SERVER database backup and recovery and presents some examples analysis.