2012年2月26日星期日

Full or Diff backup impact on Log size?

I have a question regarding FUll and differential backup.

We we take full or diff back up, does it create lot of logs ie. Does full or diff backup has any impact on log size?

Thanks

No, not in my experience.|||The backup itself will not add much to the log, but it will hold up log truncation for the duration of the backup so that if there is a lot of other activity being logged by other users during the backujp, the log can become increasingly full. Once the backup is done, the log should be able to truncate as usual (for SIMPLE recovery mode.)|||Thanks for the replies.
So taking full or diff backup does not create additional logs?. It will be just the logs of incoming transactions (not any additional logs because of full or diff backup)?

Thanks
|||That's correct.

没有评论:

发表评论