<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://discussions.blackboard.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>System Administrators (IT Pros)</title><link>http://discussions.blackboard.com/forums/42.aspx</link><description /><dc:language>en</dc:language><generator>CommunityServer 2008.5 SP2 (Build: 40407.4157)</generator><item><title>Bb 9.1 SQL Database maintenance</title><link>http://discussions.blackboard.com/forums/thread/148543.aspx</link><pubDate>Tue, 15 Jun 2010 16:24:51 GMT</pubDate><guid isPermaLink="false">cd97d549-df11-4694-84da-f4a4ce905ce0:148543</guid><dc:creator>Richard Perry</dc:creator><slash:comments>0</slash:comments><comments>http://discussions.blackboard.com/forums/thread/148543.aspx</comments><wfw:commentRss>http://discussions.blackboard.com/forums/commentrss.aspx?SectionID=42&amp;PostID=148543</wfw:commentRss><description>&lt;p&gt;We recently upgraded to 9.1, however, this problem has plagued me for many versions. &amp;nbsp;We use Microsoft DPM to back up the Bb databases, and this occurs every 30 minutes. Unfortunately, the transaction log files grow very quickly, but not at a consistent time of day that I can tell.&lt;/p&gt;
&lt;p&gt;While I can truncate the logs, this breaks the log chain for DPM. What I am looking for is to understand what is causing the tansaction logs to grow so quickly and large (20 GB), and what I can do to control their size without truncating the logs.&lt;/p&gt;
&lt;p&gt;Thoughts?&lt;/p&gt;
&lt;p&gt;Richard&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;</description></item></channel></rss>