> There is really nothing wrong with a large vertically scaled up SQL server.

Large or small, it's always going to be a single point of failure. All hardware is fallible, especially if we're talking about a commodity box rather than a mainframe or something.