Re: Shrinking or reseting log file

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 11:19:29 +0200

Maybe you are using SQL 7.0? Then check the procedure at
http://support.microsoft.com/default.aspx?scid=kb;en-us;256650. 

-- 
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Oded Kovach" <roygoldh@hotmail.com> wrote in message
news:ebNZy%23KlEHA.3104@TK2MSFTNGP14.phx.gbl...
> Thanks Dejan
>
> But it not srhiking the log file
>
> It seems that two databases are using the same log file
>
> The physical file names is diffrent but the filenames on the sql server
are
> the same.
>
> Can this cause a problem?
>
> or if other users using the filename- can this cause the problem?
>
> It is possible?
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
> message news:u7zKRkKlEHA.3612@TK2MSFTNGP12.phx.gbl...
> > Yes, there is a better way with DBCC SHRINKFILE - check the article at
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;272318.
> > Besides that, it seems like you have Full recovery model and you don't
> > backup the log. Maybe you could switch to the SImple model.
> >
> > -- 
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> > "Oded Kovach" <roygoldh@hotmail.com> wrote in message
> > news:ON7TPRKlEHA.3612@TK2MSFTNGP12.phx.gbl...
> > > Hello there
> > >
> > > I have huge database in development
> > >
> > > Its log file is so big (50Gb)
> > >
> > > the only way to deal with it (as far as i know) was to detatch it,
> delete
> > > the log file and attach it again
> > >
> > > is there better way to deal with it?
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Multi Dimensional Cases in Time Series
    ... This message does not imply endorsement from Solid Quality Learning, ... >> - in SQL Server, create a linked server to the Analysis Services ... >> Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.datamining)
  • Re: building a web site
    ... Any chance you let us know in your blog instead of flooding the NGs? ... Dejan Sarka, SQL Server MVP ... This message does not imply endorsement from Solid Quality Learning, ...
    (microsoft.public.sqlserver.datamining)
  • Re: Services account
    ... Dejan Sarka, SQL Server MVP ... >> Dejan Sarka, SQL Server MVP ... >> Solid Quality Learning ...
    (microsoft.public.sqlserver.setup)
  • Re: Data Mining - Most Commonly Update Fields
    ... you could add Insert/Update/Delete triggers to your tables and audit ... Dejan Sarka, SQL Server MVP ... This message does not imply endorsement from Solid Quality Learning, ...
    (microsoft.public.sqlserver.datamining)
  • Re: Shrinking or reseting log file
    ... > Dejan Sarka, SQL Server MVP ... >> It seems that two databases are using the same log file ... >> The physical file names is diffrent but the filenames on the sql server ...
    (microsoft.public.sqlserver.programming)