设置数据库为完整模式
alter database db set recovery full
对数据库进行完整备份 backup database db to disk='d:\tmp\db.bak' with format
误操作后备份数据库日志文件 backup log db to disk='d:\tmp\db_log.bak' WITH FORMAT
还原数据库文件
backup log db to disk='d:\tmp\db_log.bak' WITH FORMAT
还原到指定时间点
restore log db FROM DISK='d:\tmp\db_log.bak' WITH RECOVERY,STOPAT='2009-10-13 17:21:40.100'
对误操作恢复前提条件是对数据库进行过完整备份