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.

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s