The Log will not get truncate or shrink log records remain active for a long time.
You will get details of same from log_reuse_wait and log_reuse_wait_desc from sys.databases
Factors like:
very long-running transaction
paused database mirroring session, can cause the transaction log to fill.
Log truncation cannot happen during any backup or restore operation
For more details check this:
http://msdn.microsoft.com/en-us/library/ms345414.aspx
No comments:
Post a Comment