Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: SIMPLE Recovery Model Log file growth Date: Sun, 28 Oct 2012 23:21:48 +0100 Organization: Erland Sommarskog Lines: 51 Message-ID: References: <0tudnXZbkNzRyxHNnZ2dnUVZ7qednZ2d@bt.com> <17CdnaWZsLRDOBDNnZ2dnUVZ8s-dnZ2d@bt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx04.eternal-september.org; posting-host="9c1143bfab35549403b85d70ea1a57d8"; logging-data="24685"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18M4afk1hze7hVpjs1o+rBj" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:7lsoiTTwM7Yr7lpR87LQjVD1tzo= Xref: csiph.com comp.databases.ms-sqlserver:1344 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