--利用文件组备份恢复破坏的文件
RESTORE DATABASE bbb FROM DISK='D:\AAAABackup\1.bak' WITH NORECOVERY
--还原到日志点
RESTORE LOG bbb FROM DISK='D:\AAAABackup\2.trn' WITH NORECOVERY
RESTORE LOG bbb FROM DISK='D:\AAAABackup\3.trn' WITH NORECOVERY
--最后一个还原恢复正常数据库
RESTORE LOG bbb FROM DISK='D:\AAAABackup\4.trn' WITH RECOVERY
go
RESTORE DATABASE bbb FROM DISK='D:\AAAABackup\1.bak' WITH NORECOVERY
--还原到日志点
RESTORE LOG bbb FROM DISK='D:\AAAABackup\2.trn' WITH NORECOVERY
RESTORE LOG bbb FROM DISK='D:\AAAABackup\3.trn' WITH NORECOVERY
--最后一个还原恢复正常数据库
RESTORE LOG bbb FROM DISK='D:\AAAABackup\4.trn' WITH RECOVERY
go