On Thu, Mar 12, 2015 at 12:57 AM, Christof Wollenhaupt < [email protected]> wrote:
> On Wed, Mar 11, 2015 at 8:15 PM, Stephen Russell <[email protected]> > wrote: > > > 10 gigs just gets you more time till you > > start to run out of space so learn how to shrink logs. > > > > There should never be the need to shrink logs. Growing logs are a sign of a > misconfigured or misused system: > > - The recovery model isn't set according to the database's role > - No backup strategy exists > - Temporary data is written into the production database > - DML commands are used thoughtlessly like updating the same values or > using DELETE/INSERT instead of UPDATE. > -------------- > Translates to the fact that this is a whole lot bigger scope than just a dbf experience. Knowing about a backup and how to restore from one is very important. Knowing how to take a db off line and why is as well. Any RDBMS, no VFP is not in this list, has ways to help protect itself but few users have a clue as to how to use them when you use Express. ?? Temp data is written into the database? I think you mean Transactions are written to the .log of the database unless you override that. DML or CRUD is how you get Transactions for that log. We had a process that digested deposit ACH details to determine which care facilities were going to receive their payment(s). Average intake of case 600,000 USD and we could divide it 70% of funds knew who were getting paid because they used IDs in depost data, 20% we had a real good guess the $$$ amounts tied to outstanding claims, and 10% we had no clue so that money went into a slush fund used to pay of every claim at it's drop dead time frame. That process would generate about 2 gig of transaction log bloat a day. When I got to the company the db was 15 gig and the log was 400+ gig. Cleaned that up and set up transaction log shipping to our secondary data center. Knowing what logs are are pretty important. Delete * from ... make log trash where truncate table ... keeps it real clean. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmy+r0j6j8rfpn2u7bqw4dj2a5ybukewvf7fvqhxmtl2...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
