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

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

Re: Oops, transaction log created too large (SS2005)

Show all headers | View raw

 (rja.carnegie@gmail.com) writes:
> What I /believe/ I can't do, is reset the transaction
> log size directly to smaller than the original value,
> /including/ by shrinking, truncating, backing up and
> restoring, /or/ by adding a new transaction log and 
> then deleting the first one - because I /think/ that
> you can't do /that/, either.  Am I, sadly, right?
> Are there any other clever tricks to consider?
 
You can use DBCC SHRINKFILE, but you cannot shrink below the size of the 
VLFs, so it may still be too large for you.

I played with adding a new log file nad then drop the old one, but that
did not work out.

Paul Randall's blog on sqlskills.com may have some tricks that I did
not think of in a hurry.


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

Oops, transaction log created too large (SS2005) rja.carnegie@gmail.com - 2012-06-11 08:00 -0700
  Re: Oops, transaction log created too large (SS2005) "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2012-06-11 11:44 -0400
  Re: Oops, transaction log created too large (SS2005) Erland Sommarskog <esquel@sommarskog.se> - 2012-06-11 23:32 +0200
    Re: Oops, transaction log created too large (SS2005) rja.carnegie@gmail.com - 2012-06-11 20:22 -0700
      Re: Oops, transaction log created too large (SS2005) Erland Sommarskog <esquel@sommarskog.se> - 2012-06-12 10:32 +0200
        Re: Oops, transaction log created too large (SS2005) Erland Sommarskog <esquel@sommarskog.se> - 2012-06-12 12:29 +0200
          Re: Oops, transaction log created too large (SS2005) rja.carnegie@gmail.com - 2012-06-13 07:15 -0700

csiph-web