Currently we have SQL Server 2005 Standard Edition installed in a dedicated server.
Now we are planning to have a one more server as a backup server. So that if the primary server down users can continue to get the database access through the proposed new server.
I am newbie for the replication concepts. Please advice a suitable solution for our requirement.
Thanks in advance,