No t-logs in simple mode

-----Original Message-----
From: Ira Rainey
[mailto:mssqldba-ezmlmshield-x49546384.[Email address protected]
Sent: Tuesday, October 31, 2006 3:50 AM
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