Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2005 Database Mirroring setup

Status
Not open for further replies.

ryrae

MIS
Aug 31, 2004
89
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top