Re: What should be my reply?

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/06/04 

Date: Sat, 6 Mar 2004 07:12:07 +0100

Thanks for the kind words, Chip. :-) 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Chip" <anonymous@discussions.microsoft.com> wrote in message
news:7dee01c402bc$6ea1ef30$a101280a@phx.gbl...
> 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: Example Code Help - followup
    ... you might wan to create a new post with appropriate subject ... Tibor Karaszi, SQL Server MVP ... "Chip" wrote in message ...
    (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: When an update occurs, what happens to the indexes
    ... Microsoft SQL Server Storage Engine ... UPDATE which in SET changes 5 ... place in the index tree. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Indexes
    ... because we have a clustered index but I was expecting ... Only one row fit per page, so SQL Server ... You have 100000 rows in the table and 1000 rows fit per index page. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: problem with query moving data from 1 dbase to another.
    ... You register a SQL Server instance, where such an instance can have several databases. ... Tibor Karaszi, SQL Server MVP ... > you know how to connect to an existing database, ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)