SqlServer恢复到某个时间点

SQLSERVER时间还原点测试

/*=============================================================
由于误删除表或者多条记录,此时时间还原点能够恢复到误操作前的状态
=============================================================*/
1、对数据库进行备份
BACKUP DATABASE DB_TEST TO DISK='C:\DB_TEST.BAK' WITH INIT
2、先备份日志
BACKUP LOG DB_TEST TO DISK='C:\DB_TEST_LOG.BAK' WITH INIT
3、还原完全备份部分
RESTORE DATABASE DB_TEST FROM DISK='C:\DB_TEST.BAK' WITH REPLACE,NORECOVERY
4、将日志还原到删除操作前的状态(比删除时间略早)
RESTORE LOG DB_TEST FROM DISK='C:\DB_TEST_LOG.BAK'
 WITH RECOVERY,STOPAT='2005-08-17 22:42:04’

5、restore database DB_TEST with recovery

转载于:https://www.cnblogs.com/zhangfengkui/archive/2010/03/20/1690443.html