Groups > comp.databases.ms-sqlserver > #1344

Re: SIMPLE Recovery Model Log file growth

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 <esquel@sommarskog.se>
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	<XnsA0FAEDAAB5AF1Yazorman@127.0.0.1> (permalink)
References	<0tudnXZbkNzRyxHNnZ2dnUVZ7qednZ2d@bt.com> <XnsA0FA14761DAYazorman@127.0.0.1> <XMudnX_UdMRieBHNnZ2dnUVZ8hmdnZ2d@bt.com> <XnsA0FA6F96DC629Yazorman@127.0.0.1> <MN6dnd9uBcIkrBDNnZ2dnUVZ8uKdnZ2d@bt.com> <XnsA0FAA0E70E28EYazorman@127.0.0.1> <k6jnqa$rf3$1@dont-email.me> <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

Show key headers only | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SIMPLE Recovery Model Log file growth "Cathy" <Cathy@Nospam.com> - 2012-10-27 22:46 +0100
  Re: SIMPLE Recovery Model Log file growth Erland Sommarskog <esquel@sommarskog.se> - 2012-10-28 00:07 +0200
    Re: SIMPLE Recovery Model Log file growth "Cathy" <Cathy@Nospam.com> - 2012-10-28 07:59 +0000
      Re: SIMPLE Recovery Model Log file growth Erland Sommarskog <esquel@sommarskog.se> - 2012-10-28 10:58 +0100
        Re: SIMPLE Recovery Model Log file growth "Cathy" <Cathy@Nospam.com> - 2012-10-28 13:23 +0000
          Re: SIMPLE Recovery Model Log file growth Erland Sommarskog <esquel@sommarskog.se> - 2012-10-28 15:49 +0100
            Re: SIMPLE Recovery Model Log file growth "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-10-28 12:51 -0400
              Re: SIMPLE Recovery Model Log file growth "Cathy" <Cathy@Nospam.com> - 2012-10-28 21:38 +0000
                Re: SIMPLE Recovery Model Log file growth Erland Sommarskog <esquel@sommarskog.se> - 2012-10-28 23:21 +0100
                Re: SIMPLE Recovery Model Log file growth "Cathy" <Cathy@Nospam.com> - 2012-10-30 21:43 +0000
                Re: SIMPLE Recovery Model Log file growth "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-10-30 18:22 -0400
                Re: SIMPLE Recovery Model Log file growth Erland Sommarskog <esquel@sommarskog.se> - 2012-10-30 23:37 +0100

csiph-web