Sql恢复数据库到某个时间点

 backup database click to disk='d:\clickdb.bak'   ---数据库备份

 backup log click to disk='d:\clicklog.dbf'            ----日志备份

 restore database click from disk=''d:\clickdb.bak'   with norecovery

 restore log click from disk='d:\clicklog.dbf'  width recovery,stopat='2007-06-27 12:15:50' 

posted @ 2015-10-19 13:50  thanks  阅读(365)  评论(0)    收藏  举报