var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update with not logged initially and HADR
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' ;
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.
The standby database will work, but I believe the table will be unusable after the take-over.
Nick's statement is correct. HADR standby needs everything to be logged otherwise there is no way to implement the change(s).
Thanks, we have decided not to use the 'not logged initialy' statement.