Results 1 to 3 of 3

Thread: Transaction logs

  1. 08-20-1998, 02:32 PM #1
    Melissa Guest

    Transaction logs

    I am trying to import records via bcp (about 1,500,000 records) and I keep running out of disk space. Is there any way to limit or do away with the transaction log (and still be able to import)?
    Reply With Quote Reply With Quote
  2. 08-23-1998, 09:10 AM #2
    Uwe Janke Guest

    Transaction logs (reply)

    On 8/20/98 3:32:03 PM, Melissa wrote:
    > I am trying to import records via bcp (about 1,500,000 records) and I keep
    > running out of disk space. Is there any way to limit or do away with the
    > transaction log (and still be able to import)?

    I think setting the db in bulkcopy mode will help
    Reply With Quote Reply With Quote
  3. 09-05-1998, 01:46 AM #3
    Anthony Kenitzki Guest

    Transaction logs (reply)

    Actually changing the settings arent enough.

    BCP in the records in smaller chunks using the -F (firstrecord) and -L (lastrecord) switches to bcp.





    On 8/23/98 10:10:19 AM, Uwe Janke wrote:
    > On 8/20/98 3:32:03 PM, Melissa wrote:
    > I am trying to import records via
    > bcp (about 1,500,000 records) and I keep
    > running out of disk space. Is
    > there any way to limit or do away with the
    > transaction log (and still
    > be able to import)?

    I think setting the db in bulkcopy mode will help
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules