Question of the day – Clearing tran_log

Do a full backup or differential backup will clear the tran_log?

I am interested to see your response and a justification for your answer is most accepted.

Answer(Posted on 19th May 2011) :

Let me come up with the answer of this question : No,fullbackup and differential backup wont clear the tran_log.A part of tran_log is backed up to ensure consistency,however the log is never cleared.

Tran_log backup in full recovery mode will ensure that your tran_log is truncated.


One thought on “Question of the day – Clearing tran_log

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s