CODEWITHSUNDEEP
sql-serverdatabase-backupsdatabase-restorerecoverymodel
mma
mma

Reputation: 401

Why do I need to backup the transaction log for a point-in-time restore?

I'v read and experienced too, that in the SQL server's full recovery model, the restore to a point in time doesn't work correctly if I have only full database backups. It works correctly only if I backed up the transaction log also. But why do I need to backup the transaction log separately if the log file is stored also in the full database backup? Moreover, why do I need to backup the transaction log at all (anywhere, anyhow) if it's always present with all data necessary for the recovery?

Upvotes: 0

Views: 72

Answers (0)

Related Questions