CODEWITHSUNDEEP
sql-server-2005backupdatabase-backupstransaction-log
m.edmondson
m.edmondson

Reputation: 30862

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 backups only run from the last successful backup and ingore any intermediate failed full backups?

Upvotes: 1

Views: 518

Answers (2)

StuartLC
StuartLC

Reputation: 107237

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.

Upvotes: 0

Bravax
Bravax

Reputation: 10483

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.

Upvotes: 1

Related Questions