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

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

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

Relevant Pages

  • Re: [Full-disclosure] Weev, AKA Andrew Auernheimer [Fullinfo Doc(TM) revision #1]
    ... If you care about National Security I hope you visit the blog at http://twitter.com/n3td3v. ... I'll stop posting that that family info. You're going to have to find who ... Andrew has no relationship to designadventures or sealpac. ... Andrew has been detained by the FBI twice this year? ...
    (Full-Disclosure)
  • Re: .local and .com
    ... which is another reason I hate .local. ... >ISA licenses. ... Andrew Hodgson in Bromyard, Herefordshire, UK. ... use <andrew at hodgsonfamily dot org>. ...
    (microsoft.public.windows.server.dns)
  • Re: OT: Not Happy! - Updates on Dad and Dental Dog
    ... Anyway to keep this short, he went from hospital #1 to neuro-ICU at hospital #2 to a convalescent facility, then back to hospital #1, and finally back to the convalescent facility. ... he's gotten his vocabulary back; but has radically and rapidly failed on nearly every other count despite some well meaning care givers repeatedly reporting that "he's doing real well and will completely recover". ... Dental Dog: I wrote about the dogs teeth that needed pulling back about October/November. ... Hope you can get your dad settled back into his house and recovery is as good as it can be. ...
    (rec.music.makers.guitar.acoustic)
  • Re: Zap Them Babies Dead - Vets too
    ... No reason whatever to credit such a claim. ... There is no reasonable hope of her recovery, ... I have already identified the fact that your "killing" claim is a lie. ...
    (sci.econ)
  • Re: Zap Them Babies Dead - Vets too
    ... No reason whatever to credit such a claim. ... There is no reasonable hope of her recovery, ... I have already identified the fact that your "killing" claim is a lie. ...
    (sci.physics)