It would depend on what causes the water to go out. If it is from a power outage, then the sewage will still work. However if there is widespread flooding that could cause problems with the sewer system.
Experience tells me that the water system is likely to go down before the sewer system. Almost every time there is flooding around here, we get some pumps and motors from various water districts.