Halifax Water says a boil water advisory affecting more than 200,000 customers in the Halifax Regional Municipality could last up to two days.