Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: SIMPLE Recovery Model Log file growth

Show all headers | 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