是用日志还原数据库

--备份最新数据库日志
backup log businessdb to disk='e:\abc'   
--还原数据库完全备份
RESTORE DATABASE businessdb FROM DISK = N'E:\FTP\businessdb_db_200707311000\businessdb_db_200707311000.BAK' WITH NORECOVERY
--事务前滚数据恢复至某个日期
RESTORE log businessdb FROM DISK=N'e:\abc' WITH RECOVERY,STOPAT='8/10/2007 19:40:45'