开发者

SQL Server 2005 failed backup effect on transaction logs

I have an SQL Server 2005 instance whose full backup (.BAK) failed due to low disk space. However half hourly transaction log backups continue (.TRN). Assuming I have an older full backup, could these continuing transaction logs be used to restore the database?

i.e. do the transaction log bac开发者_Go百科kups only run from the last successful backup and ingore any intermediate failed full backups?


I would have thought the failed backup would be rolled back, so the ongoing transaction log backups plus a full database restore prior to these, should be sufficient to restore a database.

Having said that, I would fix this issue as soon as possible, it's not a good position to be in.


You will need ALL the logs taken since the last full Backup. You cannot roll forward a log if you have lost a previous log.

Have a look here to determine the LSNs and status of your failed backup.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜