I have two server with Win server 2003 Ent and SQL 2005 Ent. I would like to setup a DB mirroring scenerio with these two servers for redundancy purposes. I like the auto failover feature as well as the almost real-time replication of the DBs. The server does not have many DBs, but this is our reporting server so it is very important to have it available at all times. Can anyone point me to some documentation, walk-throughs, etc for configuring SQL mirroring w/failover? I would like some instructions as detailed as possible as I have never setup SQL Mirroring or Replication before. Thanks for any help you can provide.
Ryan A+, Network+, MCP, MCTS:Exchange, MCSA
Ryan A+, Network+, MCP, MCTS:Exchange, MCSA