A question on when to use bulk logged recovery mode

Hi all,

I was hoping that someone could tell me a couple of scenarios where the
bulk logged recovery mode is used and perhaps why?

I'm guessing you might use it just before doing a large data import, but
does that mean you might switch to it before the import and switch back
to full recovery once it's done? Is that a good idea?

What other instances might it be used? Perhaps in a reporting database
for some reason?

Many thanks to anyone who can advise

Kindest Regards

Simon

Simon

> I'm guessing you might use it just before doing a large data import, but
> does that mean you might switch to it before the import and switch back to
> full recovery once it's done? Is that a good idea?

BOL says
In Microsoft® SQL ServerT 2000, you can switch between full and bulk-logged
recovery models easily. It is not necessary to perform a full database
backup after bulk copy operations complete under the Bulk-Logged Recovery
model. Transaction log backups under this model capture both the log and the
results of any bulk operations performed since the last backup.

> I was hoping that someone could tell me a couple of scenarios where the
> bulk logged recovery mode is used and perhaps why?

There are some operatuions like  SELECT INTO..,CREATE INDEX under BULK
logged recovery mode  are minimally loggged.


A disadvantage is that you  cannot restore LOG file at point of time





"Simon Harvey" <nothanks@hotmail.com> wrote in message
news:uz%23a2I2HHHA.1264@TK2MSFTNGP06.phx.gbl...
> Hi all,
>
> I was hoping that someone could tell me a couple of scenarios where the
> bulk logged recovery mode is used and perhaps why?
>
> I'm guessing you might use it just before doing a large data import, but
> does that mean you might switch to it before the import and switch back to
> full recovery once it's done? Is that a good idea?
>
> What other instances might it be used? Perhaps in a reporting database for
> some reason?
>
> Many thanks to anyone who can advise
>
> Kindest Regards
>
> Simon