Server1 ( DB1) <--> Application Server
|SQL2008 One wayTransactional Replication (Peer to Peer)
Server2 (DB2) <-> WebServer for SQL query
1. The main Application Server is using DB1.
2. Users are querying informative from DB2.
I am in the planning stage of DB Replication.
When there are failure to Server1, i will point the application Server to use Server2 (DB2) to temporately resume all the operation(s).
My question is
Whatelse do i need to do to handle the stopped DB replication processes (in detailed steps)?
SQL Expert Please help.