Re: My Database doesnt appear to have a transaction log!

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 13:39:17 -0500

The main reason this gets set is if you don't care to issue regular log
backups or don't care about point in time recovery. Fairly static / read
only or development db's are good candidates for this option. I would read
up in booksonline under "recovery models". It may be different in 7.0 but
it should point you in the right direction. 

-- 
Andrew J. Kelly  SQL MVP
"Dooza" <steve@whatareyoudooza.tv> wrote in message 
news:%23LzWee81EHA.2292@TK2MSFTNGP15.phx.gbl...
> Hi Andrew,
> I have found the option. Is there any reason why this would be ticked? Is
> there performance benefits to using this? Any advice would be warmly
> welcomed.
>
> Kind regards,
>
> Steve
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:%23NA8WU71EHA.1524@TK2MSFTNGP09.phx.gbl...
>> Right click on the database and choose "Properties".  Then take a look at
>> the "Options" (I believe that is what 7.0 called it) tab.  The help 
>> button
>> and BooksOnLine should guide you from there.
>>
>>
>> -- 
>> Andrew J. Kelly  SQL MVP
>>
>>
>> "Dooza" <steve@whatareyoudooza.tv> wrote in message
>> news:eetslu61EHA.1300@TK2MSFTNGP14.phx.gbl...
>> > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
>> > news:uzuWE4h1EHA.2624@TK2MSFTNGP11.phx.gbl...
>> >> If the tran log didn't exist your db would not be running<g>.  Sounds
>> >> like
>> >> someone placed the db in Simple recovery mode or if 7.0 they set
> truncate
>> >> Log on Checkpoint.
>> >
>> > Hi Andrew,
>> > I am runnung 7.0. Where do I find the Truncate Log on Checkpoint?
>> >
>> > Steve
>> >
>> >
>>
>>
>
>