Thanks for all your help on this.

To clarify then: when the database recovery model is set to Simple the
truncate log on checkpoint option is automatically set. So unless you have
some problem with your database performing checkpoints, or you have
uncommitted transactions in the log the log will get cleared every time a
checkpoint occurs.

Cheers.

Ira

-----Original Message-----
From: Ira Rainey
[mailto:mssqldba-ezmlmshield-x49546384.[Email address protected]
Sent: 31 October 2006 09:50
To: LazyDBA Discussion
Subject: Recovery Models


Am I right in thinking that when I set my recovery model (SQL 2000) to
'Simple' the log file will simply overwrite itself when it becomes full?

I know that by setting this you can only truncate the log and not actually
back it up, but I can't find anything clarifying that the file effectively
eats itself.

Cheers.


Ira Rainey



Senior Software Developer

Avon Data Systems

http://www.avondata.co.uk <http://www.avondata.co.uk/>

Tel: 0117 9109166 Ext: 229




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page