sqlserver2005备份还原到时间点

利用SQL语句还原到时间点
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、还原数据库全备份NORECOVERY
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='2010-08-17 22:42:04’
5、restore database DB_TEST with recovery

利用界面工具恢复

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25685427/viewspace-695732/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25685427/viewspace-695732/