XPost: microsoft.public.sqlserver.server   
   From: reb01501@NOyahooSPAM.com   
      
   Gene Wirchenko wrote:   
   > Hello:   
   >   
   >      The text that I am studying is Robin Dewson's "Beginning SQL   
   > Server 2008 Express for Developers From Novice to Professional"   
   > published by Apress.  It generally quite readable, but I am running   
   > into some trouble in the chapter on backups.  I have checked Books   
   > Online for some of this, but to no avail.   
   >   
   >      Because I do have some confusion here, my questions might not   
   > quite be correct for what I need.  I want the basic terms, not the ins   
   > and outs of how they are used.  If I get that, then my text will   
   > probably make much more sense for the rest.   
   >   
   >   1) I need some definitions:   
   >           physical log  (I think this a fixed-length file.)   
   >           logical log   
   >           virtual log   
   >   
   I think this is what the author has in mind:   
   Physical log is simply the .ldf file   
   Logical log is the definition of the log in the sys.objects table.   
      
   Just as a database will have both a logical name and a physical file name,   
   so will a transaction log. For example, you might have a database called   
   "mydatabase". "mydatabase_data" might be its logical name as stored in   
   sys.objects. "mydatabase_data.mdf" might be the physical filename.   
   "mydatabase_log" would be the logical name stored in sys.objects, and   
   "mydatabase_log.ldf" would be the physical file name.   
      
   "virtual log" I suspect refers to the VLFs (virtual log files) that you will   
   find discussed in books online.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)