Re: is it possible to re-build index without logging?

From: Steve Lin (lins_at_nospam.portptld.com)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 13:36:58 -0800

as i said, the database is write intensive. so simple recovery mode might be
too risky. is there a way to run a scheduled re-index job as a non-logged
operation?

thank you so much for the help.

steve

"Andrew J. Kelly" <sqlmvpnoooospam@shadhawk.com> wrote in message
news:ujUS9aFGEHA.2876@TK2MSFTNGP09.phx.gbl...
> You can try changing the recovery mode to Bulk Logged or Simple and see if
> that helps. Do only a few tables at a time and backup the log in between.
>
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Steve Lin" <lins@nospam.portptld.com> wrote in message
> news:#otAPXEGEHA.3288@TK2MSFTNGP12.phx.gbl...
> > nt5, sql2k
> >
> >
> >
> > i have a vendor application on one of my sql servers.
> >
> > this application has many tables, and each tables have many indexes.
it's
> > very write intensive (because when a record is inserted, it's insereted
to
> > many many other tables, and that behavior can't be changed). the problem
> is
> > page split happened often, but when i tried to reindex tables once a
week,
> > the log file run out of space.
> >
> >
> >
> > can anyone offers some good solutions to my problem?
> >
> > thank you!!
> >
> >
> >
> > Steve
> >
> >
>
>

Relevant Pages

  • Re: is it possible to re-build index without logging?
    ... Microsoft SQL Server Storage Engine ... "Steve Lin" wrote in message ... >> Andrew J. Kelly SQL MVP ... >>> the log file run out of space. ...
    (microsoft.public.sqlserver.server)
  • Re: recover mode and the transaction log file question
    ... Sounds like you didn't get the recovery mode set properly for some reason. ... <alter database leads set recovery full> ... > I have setup the log file to not grow at all. ... > I check the log file status using the "DBCC SQLPERF" command ...
    (microsoft.public.sqlserver.programming)
  • Re: recover mode and the transaction log file question
    ... > 'recovery mode' options and have set the recovery mode for my test ... > I have setup the log file to not grow at all. ...
    (microsoft.public.sqlserver.programming)
  • Re: Shrinking DB
    ... I meant instead of shrining the log file every night. ... If you don't 'carry' about the data just set up recovery mode to simple so ... >> schedule, ...
    (microsoft.public.sqlserver.server)
  • Re: Is transaction log file reuseable after data file is Restored?
    ... It is not for the COMMITTED transactions that the log files are used for. ... Committed transactions are deleted from the log file upon a checkpoint in SIMPLE RECOVERY mode. ...
    (microsoft.public.sqlserver.server)