1.备份完整数据库;
BACKUP DATABASE db TO DISK='c:\db.bak' WITH FORMAT (format是指覆盖以前备份的数据)
2.备份数据库事务日志;
BACKUP LOG db TO DISK='c:\db_log.bak' WITH FORMAT,NO_TRUNCATE (no_truncate是指允许在数据库损坏时备份日志,在数据库没有损坏的前提下,可以不使用该参数)
3.还原数据库文件
RESTORE DATABASE db FROM DISK='c:\db.bak' WITH NORECOVERY
4.使用事务日志还原
RESTORE LOG db FROM DISK='c:\db_log.bak' WITH RECOVERY
5.还原数据日志到时间点
restore log db2 from disk='db_log_backup' with stopat='2003/4/22 9:57'
阅读(473) | 评论(0) | 转发(0) |