XPost: microsoft.public.sqlserver.server   
   From: reb01501@NOyahooSPAM.com   
      
   Eternal wrote:   
   > 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.   
      
   Oops, "sys.objects" should read "sys.database_files". Sorry.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)