How to Stop Logging

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Surajit Laha
    #1

    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
    Tags: None
    • Simon Hayes
      #2
      Re: How to Stop Logging

      s_laha@rediffma il.com (Surajit Laha) wrote in message news:<ba8ee108. 0401290212.6def eb00@posting.go ogle.com>...[color=blue]
      > 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[/color]

      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

        Comment

        Previous template Next
        Working...