根据日志恢复MSSQL数据库

1.备份一个当前在日志备份
backup log winmydns to disk='d:\t2.log'

2.找到一个错误操作之前的全备份恢复,注意使用with norecovery 参数
restore database winmydns from disk='d:\winmydns\db\winmydns.bak' with norecovery

3.根据日志来还原设置还原时间点
restore log winmydns from disk='d:\t2.log' with stopat='2006-12-02 12:00:30.717'

如何MSSQL日志清理，请查看：http://www.zbusa.com/Info/faq/42.html