Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    16

    Unanswered: How to log select into/bulk copy transactions

    Is there a way to be able to use select into and/or bulk copy statements AND have them logged into the transaction log? If I uncheck select into/bulk copy, these statements cannot be performed. If I leave them checked, the operations are not logged, making my transactions logs invalid.

    Ed

  2. #2
    Join Date
    Apr 2002
    Posts
    31
    Builk copy operation are specially designed to be NONLOGGED. Since you have got operations that not looged in tranlog, there is no way to get db in consistant state using this tranlog. Thats why you need to perform full db backup.

    In SQL2k u dont need perform full backup after builk ops anymore since they are logged thru BCM pages.

    HTH,
    OBRP

Posting Permissions

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