误操作引起的恢复方法:
1,备份事务日志
backup log dbName to disk='fileName'
2,恢复以前的全库备份
restore database dbName from disk='fileName' with norecovery
3,恢复最后一个日志备份到指定时间点
restore log dbName from disk='fileName'
with stopat='date_time'
4.恢复数据库状态
RESTORE DATABASE dbName WITH RECOVERY
灾难恢复方法:
1.备份当前日志尾部
BACKUP LOG dbName TO DISK='fileName' WITH INIT,NO_TRUNCATE
2.恢复以前的全库备份
restore database dbName from disk='fileName' with norecovery
3.恢复事务日志
restore log dbName from disk='fileName' with norecovery
4.恢复数据库状态
RESTORE DATABASE dbName WITH RECOVERY