Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33

    Question Unanswered: Transaction Log Full

    Hi Friends,

    While BCP In 700 tables my transaction log is full. I have automated the process now at 270th table the process has aborted but to full transaction log. How do i procees

    Thank You
    A friend in need is a friend in deed

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Code:
    use master
    go
    exec sp_dboption YourDB, "trunc log", true
    exec sp_dboption YourDB, "select into", true
    exec sp_configure interval_in, 3
    go
    use YourDB
    go
    checkpoint
    go
    Then you can use the option -b using bcp

Posting Permissions

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