“Does Full backup breaks the log chain?”

I have my DBA really worried about running full backup. I asked him the reason and he told him that if he run the full backup then log chain will be broken.

INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.

  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers

What do you think? Is this true? Does he need to be worried?

The answer and suggestion to all DBAs is that Full backups do not break log chain. Full backups do not truncate the transaction log. Only log backups or switch to simple recovery model can cause the log chain broken. So go ahead with full backups without thinking log chain breaks.

Oh yes one more thing here. Full backups do reset the differential base if you are using differential backups.

Regards,
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com

Advertisements

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s