Our company is looking for how to provide 24x7 reliable DB. We are using MS SQL Server. We’ve been looking into immediate updating Transactional Replication of the Production DB into the Backup DB. And in case of the Production DB failure quick switch to the Backup DB. It seems to me that Transactional Replication does NOT MEANT for this goal. I know that Oracle have Stand-by DB for this purpose. What about MS SQL Server? Please advise.