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’
由于误删除表或者多条记录,此时时间还原点能够恢复到误操作前的状态
=============================================================*/
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
