I am trying to set up a transactional replication database on two MSSQL 2008 Standard servers. We need to be able to query off of the subscriber database, but we would also like to be able to use the subscriber as a backup if the primary server fails.
Is it at all possible to use the subscriber database, if it is replicating ALL of the data from the publisher, as a backup primary database, or do I need to use some other form of replication/mirroring that still allows near real-time querying?