We have live and stand-by database servers. Both are SQL Server 2008 databases and hosted on Windows Server 2003.
May I know the best practice that people follow to synchronize the 2 databases (live and stand-by) so that we could make sure the stand-by server up whenever the live server is down for any reason.
It would be great if you could also provide a reference document or web references (if needed).