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

Re: SIMPLE Recovery Model Log file growth

From	"Cathy" <Cathy@Nospam.com>
Newsgroups	comp.databases.ms-sqlserver
References	(2 earlier) <XMudnX_UdMRieBHNnZ2dnUVZ8hmdnZ2d@bt.com> <XnsA0FA6F96DC629Yazorman@127.0.0.1> <MN6dnd9uBcIkrBDNnZ2dnUVZ8uKdnZ2d@bt.com> <XnsA0FAA0E70E28EYazorman@127.0.0.1> <k6jnqa$rf3$1@dont-email.me>
Subject	Re: SIMPLE Recovery Model Log file growth
Date	2012-10-28 21:38 +0000
Message-ID	<17CdnaWZsLRDOBDNnZ2dnUVZ8s-dnZ2d@bt.com> (permalink)

Show all headers | View raw

I feel we are somewhat getting sidetracked.

>> You have several log files for this database?

I have several databases using single log files

> 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.

Below a result of your script (obviously showing all databases on the 
server)

I have added file sizes for log files and drive letters. I am only 
experiencing problems on the G drive

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:
SharePoint_AdminContent_X SIMPLE 47 G:
ManagedMetadataDB_Test SIMPLE 0 G:
SecureStoreServiceDB_Test SIMPLE 0 G:
StateServiceDB_Test SIMPLE 0 G:
ProfileDB_Test SIMPLE 63 G:
SyncDB_Test SIMPLE 135 G:
SocialDB_Test SIMPLE 0 G:
WebAnalyticsStagingDB_Test SIMPLE 52 G:
WebAnalyticsReportingDB_Test SIMPLE 18 G:
UsageDB_Test SIMPLE 26 K:
SearchServiceApplication_Test SIMPLE 69 G:
SearchServiceApplication_Test_PropertyStore SIMPLE 148 G:
SearchServiceApplication_Test_CrawlStore SIMPLE 47 G:
WSS_Search_Test SIMPLE 148 G:
Intranet_Content_Test FULL 319 J:
MySites_Content_Test_1 SIMPLE 6 J:
MySites_Content_Test_2 SIMPLE 6 J:
TeamSites_Content_Test SIMPLE 9 J:
Teams_Test_Conetnt_DB1 SIMPLE 9 J:
MySites_Content_OWA_Test SIMPLE 9 J:
Intranet_OWA_Content_Test FULL 19 J:
XS_Teams_Content_DB1 SIMPLE 42 J:

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