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

Re: SIMPLE Recovery Model Log file growth

From	"Bob Barrows" <reb01501@NOSPAMyahoo.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SIMPLE Recovery Model Log file growth
Date	2012-10-28 12:51 -0400
Organization	A noiseless patient Spider
Message-ID	<k6jnqa$rf3$1@dont-email.me> (permalink)
References	(1 earlier) <XnsA0FA14761DAYazorman@127.0.0.1> <XMudnX_UdMRieBHNnZ2dnUVZ8hmdnZ2d@bt.com> <XnsA0FA6F96DC629Yazorman@127.0.0.1> <MN6dnd9uBcIkrBDNnZ2dnUVZ8uKdnZ2d@bt.com> <XnsA0FAA0E70E28EYazorman@127.0.0.1>

Show all headers | View raw

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.

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