469,081 Members | 1,805 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

How to Stop Logging

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
Jul 20 '05 #1
1 3365
s_****@rediffmail.com (Surajit Laha) wrote in message news:<ba**************************@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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by lawrence | last post: by
6 posts views Thread by ScareCrowe | last post: by
1 post views Thread by jjesso | last post: by
6 posts views Thread by pmatos | last post: by
2 posts views Thread by Nathan | last post: by
56 posts views Thread by valentin tihomirov | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.