From: esquel@sommarskog.se   
      
   Cathy (Cathy@Nospam.com) writes:   
   > I have added file sizes for log files and drive letters. I am only   
   > experiencing problems on the G drive   
   >   
      
   I am getting more and more confused. From your initial post, I assumed   
   that you had problem with a particular database. I know nothing about   
   Sharepoint, so I was not aware of that there are multiple databases,   
   and in any case you talked about *the* log file growing.   
      
   Now you say that you are only experience on the G drive, but you are   
   not saying with which database. Am I right interpret that your real   
   problem is that you have space shortage on the G drive, but you have   
   investigated which exact database that is causing the problem?   
      
   Anyway, of these numbers:   
      
   > Name Recovery Model FileSizeMB Drive   
   > master SIMPLE 1 E:   
   > tempdb SIMPLE 10 F:   
   > model FULL 0 E:   
   > msdb SIMPLE 9 E:   
   > SharePoint_Config_Test SIMPLE 5192 G:   
      
   This database has a log file which a little more than 5GB, and the rest   
   are small - some too small for my taste. 5GB may be more than is needed,   
   but I assume that the data file is considerably more than 5GB in size,   
   am I right?   
      
   Then again, the name suggests that this is a test database. Is it actually   
   used?   
      
   When you check log_reuse_wait, did you check it for all databases?   
      
   Then again, if you get space problems on the a drive because of a total   
   6-7 GB in log files, I get worried. That is not really a lot, is it?   
      
   > Intranet_Content_Test FULL 319 J:   
   > Intranet_OWA_Content_Test FULL 19 J:   
      
   While these two are on a different disk, note that they have full   
   recovery.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)