From: reb01501@NOSPAMyahoo.com   
      
   Erland Sommarskog wrote:   
   > Cathy (Cathy@Nospam.com) writes:   
   >> I have several Log files, The largest appears to be 5GB and is the   
   >> one I am looking at   
   >   
   > You have several log files for this database?   
      
   No, I think she means there are several databases used by Sharepoint, each   
   with its own log file of course. The Sharepoint installer only creates one   
   log file per database. If multiple log files are present for a database,   
   they were added manually.   
      
   Cathy, 14Gb is nowhere near enough space for the several databases used by   
   sharepoint - which databases are present depends on what Sharepoint services   
   are turned on.   
   I suspect that only one of the databases has been set to Simple recovery.   
   You need to check the other databases.   
      
   Here is a script to use (depending on your version of SQL Server) to list   
   the recovery models of all your databases:   
      
   SELECT Name   
   , DATABASEPROPERTYEX(Name,'RECOVERY') AS [Recovery Model]   
   FROM master.dbo.sysdatabases   
      
   If this does not work on your server due to version incompatibility, just   
   google "sql server list databases recovery model" to find one that will work   
   on your server.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)