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

Re: SIMPLE Recovery Model Log file growth

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SIMPLE Recovery Model Log file growth
Date	2012-10-28 00:07 +0200
Organization	Erland Sommarskog
Message-ID	<XnsA0FA14761DAYazorman@127.0.0.1> (permalink)
References	<0tudnXZbkNzRyxHNnZ2dnUVZ7qednZ2d@bt.com>

Show all headers | View raw

Cathy (Cathy@Nospam.com) writes:
> 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.

You can use DBCC OPENTRAN to see if there are any open transactions in the 
database.

Has the database ever been involved in replication? Replication also uses
the log, and non-replicated transactions will cause the transaction to 
grow.

And doublecheck that you really are in simple.


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