We are running a Web Server with ASP pages and SQL Server 2008 on Windows Server 2008 Enterprise Edition. We are looking for an efficient solution to mirror the Web Server and SQL Server with automatic failover from the principal server. We will be hosting the mirror web server and mirror SQL server on dedicated servers hosted at different locations.
Part A: Mirroring the Web Server.
Mirroring of the web Server can be done by adding primary and secondary name servers in the DNS control panel. When the principal web server fails, DNS name server automatically routes the traffic to the secondary web server.
Also, we would like to have a script to simultaneously push the updated files from the test server to both the principal web server and mirror web server.
Part B: Mirroring the SQL Server
Mirroring of the SQL server 2008 can be done using SQL Server’s built-in high safety automatic failover Mirror Utility. We can use a witness server to make sure the principal SQL server and the secondary SQL servers are synchronized. When there is failover of the principal SQL server, secondary mirror server shall automatically seamlessly take over the functions of the database. Later, when the principal server is restored, the data from the mirror server shall be synched with the principal server and principal server shall take over the function of the database. If possible, the mirror SQL server shall also act as load balancing mirror server.
After the mirror web server and mirror SQL servers are installed, they shall be tested to make sure that the automatic failover works smoothly when the principal server fails and vice versa.
We have hosted the principal and the mirror servers on dedicated servers at different locations and will provide you the remote access details.
You can either quote the combined price for the total project (Part A and Part B ) as described above or quote the price for only Part A or Part B, depending upon your expertise and experience.