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

SIMPLE Recovery Model Log file growth

From	"Cathy" <Cathy@Nospam.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	SIMPLE Recovery Model Log file growth
Date	2012-10-27 22:46 +0100
Message-ID	<0tudnXZbkNzRyxHNnZ2dnUVZ7qednZ2d@bt.com> (permalink)

Show all headers | View raw

I have set a database to SIMPLE Recovery Model thinking I wont have to worry 
about the log file size.

The database is used by Sharepoint but as we have no requirement to restore 
to a point in time and will be happy to restore to the last backup, 
(normally run in the middle of the night)

I have noted that the log files are getting bigger and bigger and causing 
disks to run out of space.

My question is. what is the simplest way in which to close any open 
transactions in the log file and truncate and shrink the file.

I am hoping to get a set of TSQL commands I can run that might take the data 
offline, start it up again, perhaps set a checkpoint, truncate the logfile, 
shrink the logfile and start afresh

Any help will be greatly appreciated

C

Back to comp.databases.ms-sqlserver | Previous | Next — 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