通过事务日志将数据库恢复到某一时间点。
backup log FaxSun to disk='h:/baklog'--备份当前日志文件
restore database FaxSun from disk='H:/FaxBak.dat' with norecovery--用旧的备份恢复数据库,加norecovery选项
restore log FaxSun from disk=h:/baklog' with recovery,stopat='2003-08-25 13:00:00.000'--根据日志文件将数据库恢复到某一时点
backup log FaxSun to disk='h:/baklog'--备份当前日志文件
restore database FaxSun from disk='H:/FaxBak.dat' with norecovery--用旧的备份恢复数据库,加norecovery选项
restore log FaxSun from disk=h:/baklog' with recovery,stopat='2003-08-25 13:00:00.000'--根据日志文件将数据库恢复到某一时点