question

pradnyag41 avatar image
pradnyag41 asked

How does transaction log backup job work without a full backup of database?

In our environment we have restored a DB with name TEST from existing DB XYZ backup file on that instance. The tlog backup job is running fine without full backup for TEST DB
transaction-logbackup-restore
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

The point is that Tlog backup job is running for TEST DB though there is no any full backup for this DB. Its also creating .trn files for TEST DB with full backup.
0 Likes 0 ·

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
It *should* ignore the Test DB until a full backup has been done. However... Are you getting any error messages from your TLog backup job?
7 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

It won't matter if the full backup came from another instance; it becomes the anchor for the log chain on whichever server you restore it. One full backup can be the source for hundreds or thousands of databases and they will all be able to take transaction log backups based on that single full backup.
3 Likes 3 ·
A full backup *has* been done. They restored from it.
2 Likes 2 ·
we dont have any full backup for TEST DB till date.
0 Likes 0 ·
I'd be curious to learn how you restored database TEST without a full backup of database XYZ. That would be the full backup that is anchoring the log chain.
0 Likes 0 ·
ok I got your point. But I have TEST2 DB which is restored on instance 1 from some other DB backup of other instance at on that time also tlog backup job is working fine.
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.