Re: Transaction vs Logical logs

From: Richard Krenek <rkrenek@ihs.com> > >Stupid question time: >What is the difference between a Transaction log and Logical log and >more importantly when would you want to use a transaction log? Here are >the defenitions I was able to find but from them it sounds like >Transaction logs are of no use (I know this is not the case) because >everything I want to restore a database is contained in the logical >logs. > >Transaction Logs pick up changes to data since last storage-space >backup. > >Logical Logs contain records of all changes (check points) that were >performed on a database during the period the log was active. > > > >All that really matters to me right now are the 2 logs in the context of >backing up and restoring a database: Please use small words. If I understand you correctly, you're using two terms to describe the same physical thing. Perform a Vulcan mind-meld. :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com