SEO

#1 (**permalink**) 02-28-2008, 07:45 PM

Hi,

I am doing some resource hungry tasks (some extraction and loading
through DTS), for which each time the SQL Server Log files gets filled
up!

Is there any way to stop the logging (like as during restore)?

Thanks in advance.

-surajit

#2 (**permalink**) 02-28-2008, 07:45 PM

s_laha@rediffmail.com (Surajit Laha) wrote in message news:<ba8ee108.0401290212.6defeb00@posting.google. com>...
> Hi,
>
> I am doing some resource hungry tasks (some extraction and loading
> through DTS), for which each time the SQL Server Log files gets filled
> up!
>
> Is there any way to stop the logging (like as during restore)?
>
> Thanks in advance.
>
> -surajit

You can't disable logging, but you could set the database recovery
model to simple during the load. You might also be able to load in
batches, instead of in a single transaction, which should require less
log space. The DTS Transform Data Task allows you to specify a batch
size, for example.

Simon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to Stop Logging