Ok...venturing into new territory here. Always had one web site with connections to SQL Server.
Web SIte of one server...database(s) on another.
Recently our network guys have been having some real issues with the database server(s)
Is there a step by stem somewhere for me to set it up where (terminology?) on server is mirrored on another and IF my web site can't connect to server1...or loses connection...there's a failove to the other database server?
We have about 145 clients users on the We IntraNet site. It may frow to 200.