Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2010
    Location
    The Netherlands
    Posts
    20

    Question Unanswered: Update with not logged initially and HADR

    Hello,

    We want to update a very large table in steps.
    While updating we want to use the not logged initially, as following

    ALTER TABLE log ACTIVATE NOT LOGGED INITIALLY;
    update log set message = 'XXX' where timestamp >='2010-08-25 00:00:00.000000' and timestamp <'2010-08-26 00:00:00.000000' ;
    COMMIT;

    We know that in this case the HADR database won't get updated.
    But will the HADR database still work and can we use the table if we need to set the HADR database as primary?

    Thanks in advance.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The standby database will work, but I believe the table will be unusable after the take-over.

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Nick's statement is correct. HADR standby needs everything to be logged otherwise there is no way to implement the change(s).
    Dave

  4. #4
    Join Date
    Nov 2010
    Location
    The Netherlands
    Posts
    20

    Thumbs up

    Thanks, we have decided not to use the 'not logged initialy' statement.

Posting Permissions

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