We are running a webServer with ASP pages and SQL server on Windows Server Standard Edition Service Pack 2. We are looking for efficient solution to mirror the web site and SQLserver in the event of failover of the principal server. Mirroring should be done continuously and monitored. We will take care of hosting the principal and the mirror servers. When there is failover of the principal web server or the SQLserver, mirror server should seamlessly take over the functions of the principal server. Until the principal server is restored, snapshot backup and tape backup should be taken on Mirror server. When the principal server is restored, the data from the mirror server should be synched with the principalserver and the principal server should take back the functions.
Mirroring can be done using SQL Server Mirror Utility or through Virtualization, whichever is more efficient, economical, robust and suitable for this project.