add_action( 'activate_blog',"SOFT_run_at_blog_activation");

function SOFT_run_at_blog_activation($id){
  global $wpdb;
  $Q="SELECT * FROM ".$wpdb->prefix."options WHERE option_name LIKE 'MY_OPTION'";
  $key=$wpdb->get_row($Q);
  if($key){
    switch_to_blog($id);
    update_option('MY_OPTION',$key->option_value);
    restore_current_blog();
  }
}