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

    Unanswered: How to prevent non logged updated to database

    I want to make sure all updates to a db are logged so that backup/restore of translogs go through correctly. We have no need for bulk copy operations, so having non logged transactions don't offer any benefits. Can I do this by making sure select into/bulk copy is unchecked?

    Ed

  2. #2
    Join Date
    May 2002
    Posts
    16
    Actually...what I should be asking is that, instead of PREVENTING non logged operations, will unchecking Select Into/Bulk Copy make sure that all transactions that create changes in a database are logged? Is there anyway to do this?

    Ed

  3. #3
    Join Date
    Apr 2002
    Posts
    31
    Checking or unchecking this option will not prevent "logged" transaction from logging. Do not forget to do full backup after changing this option.

    HTH,
    OBRP

  4. #4
    Join Date
    May 2002
    Location
    New York
    Posts
    35
    Do not forget about TRUNCATE <table_name> which is also non logged.

Posting Permissions

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