Home Forums Article Discussions Article Discussions by Author Discuss content posted by James DiMauro A Story of the Deleted Transaction Log RE: A Story of the Deleted Transaction Log
SuperDBA-207096
SSCrazy Eights
Points: 8176
More actions
July 14, 2008 at 9:30 am
#842492
Bill Whitman (7/14/2008)oberhardt is correct. A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.
Bill Whitman (7/14/2008)
A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.
Probably don't want to shrink the log unless you absolutely have to..