Re: Transaction logs getting too large

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 05/18/04 

Date: Tue, 18 May 2004 07:23:48 -0500

If you don't care about transaction logs you can set the recovery model to simple

ALTER DATABASE YourDatabase SET RECOVERY SIMPLE

You will probably need to shrink the log file after setting the recovery model to simple. Refer to DBCC SHRINKFILE within Books Online (within the SQL Server program group). 

-- 
Keith
"srgallan" <anonymous@discussions.microsoft.com> wrote in message news:e8ec01c43cd0$a10fae00$a501280a@phx.gbl...
> Hello everyone,
> 
> I was hoping to get a little guidance if someone has a 
> chance.  We have SQL2000 here for applications that 
> require it's services in the back-end.  One paticular 
> application "we will call application A" has a very small 
> database but an 80GB transaction log file.
> 
> This is not a critical database, this application is just 
> used by the IT department for file deployments.
> 
> Transaction logs are used for recovery correct?  Can we 
> set it so that older information in the logs are purged?  
> Truncate the log and delete older one's?

Relevant Pages

  • Re: Transaction log ???
    ... I don't really understand your first question, but the log is there to ... then the simplest option may be to set your database to ... the simple recovery model - the log will then be truncated ...
    (comp.databases.ms-sqlserver)
  • Re: archive logging the log file
    ... I believe you are referring to transaction logs. ... transaction logs for databases in the FULL or BULK_LOGGED recovery model is ... backups in conjunction with database backups as part of your recovery plan. ...
    (microsoft.public.sqlserver.server)
  • Re: Log file is increeasing too much
    ... > turned the recovery mode to simple and I put the option auto shrink on. ... >> If you are using the FULL recovery model, you would need to backup the log ... >> transaction, hence all the data is either committed or rolled back. ... >>> i have a database and a proccess which delete everything from database and ...
    (microsoft.public.sqlserver.server)
  • Re: Will this shrinkfile method work?
    ... - have been very informative with understanding how to handle log files. ... There is no need to change the recovery model at all. ... while for it to shrink but it will. ... Right click the database, choose TASKS - SHRINK - DATABASE ...
    (microsoft.public.sqlserver.setup)
  • Re: Will this shrinkfile method work?
    ... There is no need to change the recovery model at all. ... If the active VLF is near the end of the log file it may take a little ... while for it to shrink but it will. ... Right click the database, choose TASKS - SHRINK - DATABASE ...
    (microsoft.public.sqlserver.setup)