It depends. There are "true" sine wave battery backups, and regular ones. I have a regular one and if I connect that to my computer it works great, but my Iwaki pump makes a crazy noise.
My backup is only connected to my tunze pump. It will last about 24 hours in it's current config, but if I was buying new I'd buy the Tunze solution that's DC to DC for extra efficiency.
It did save my tank. We had fires that wiped out the community next to ours, but never jumped the 15 freeway. This was about 2 years ago. We were evacuated for a week, and the logs show that power was out in my system for about a day and a half. I have no idea what temp did, but that one Tunze 6105 kept flow going and the corals and fish all survived.
My advice? Keep flow going and that's it. The most important thing is flow to bring O2 to corals, and propeller pumps are very low power so they can run a long time.
Whiskey