Re: What should be my reply?

From: Chip (anonymous_at_discussions.microsoft.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 06:16:20 -0800

Hi Tibor,

Thanks for the support!. I have replied my mail :-). Well
not to mention, I am a big fan of you and thanks for
attaching ur URL with the signature. I could see ur pic &
ur bio.

Also Thank to al dave for his views.

Will be back to forum with another doubt.

Sincerely

Chip
>-----Original Message-----
>Never ever delete the transaction log for a production
database. Chances are
>that the database will go suspect and the only way to
recover is to restore
>from backup. If that isn't enough, ask him where in the
MS literature did he
>find the recommendations to delete the tlog file. This is
just something you
>don't do. It seems like he is lacking understanding about
how SQL Server
>work regarding the tlog, backup of tlog etc. Perhaps
recommend him to the
>appropriate section in Books Online?
>
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>
>"Chip" <anonymous@discussions.microsoft.com> wrote in
message
>news:771801c402a8$8d9db220$a301280a@phx.gbl...
>> Na, He is asking me to delete the trn log . I am more
>> worried why he was using the term ** Unnessary
Transaction
>> Log** which I am not able to digest and more over no
body
>> will if know little about Transaction Log Architecture &
>> advantages. I need few sound practical points to say him
>> no for *deleting* trn log file. This Database is running
>> since one-and-half years with the same tran log.
>>
>> Regards
>>
>> Chip
>> >-----Original Message-----
>> >Isn't he just asking you to backup and shrink the tlog?
>> This would seem to
>> >be fine. I can't see how the size of the tlog affects
the
>> performance of the
>> >database though.
>> >
>> >--
>> >Niall Litchfield
>> >Oracle DBA
>> >Audit Commission UK
>>
>
>
>.
>

Relevant Pages

  • Re: how to roll forward(point in time)
    ... >alter database pit set recovery full ... >Jasper Smith (SQL Server MVP) ... >> Tues tlog 6pm ... >> after the crash, I should be able to do a tlog backup, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 speed problems
    ... and each batch requires a network trip. ... I would look at the disk config for the tlog. ... execute a batch the same time as SQL Server performs a checkpoint. ... > Every second the database gets updated with a timestamp and 50 new values. ...
    (microsoft.public.sqlserver.programming)
  • Re: What should be my reply?
    ... Tibor Karaszi, SQL Server MVP ... "Chip" wrote in message ... >>find the recommendations to delete the tlog file. ... >>Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: IndexDefrag Production Impact
    ... I totally agree & in case this isn't clear for Jaxon - the .tlog grows ... the backup device / file might be substantially larger that it would have ... > Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: LDF files keep growing back....
    ... you are invalidating your transaction log and the tlog will only be ... valid again after you do a full backup (any tlog backup you do between ... which would do what you're asking for (as well as periodically shrink ...
    (microsoft.public.sqlserver.server)
Loading