How to synchronize databases between two servers?

I would like to know how I can synchronize my SQL Databases between two servers. These two servers are in two different places and both are running SQL 2000 on a Windows 2000 Server.
Scenario
One of these servers is my active one right now which is working as a web server for my hosting company. I would like to add my second server as DNS2 for my hosting clients so if incase the DNS1 (my current active server) failed, the DNS2 comes to play and provide my clients the same information as DNS1
Any help would be greatly appreciated
Thanks
MikMike you may want to implement any of the following :
1) log shipping
2) replication (may have more administrative issues)
3) clustering (expensive, but more realistic with your
requirement, may require administration too).
If you are looking at a solution that is not too expensive
and not too cumbersome to maintain, i would go the
logshipping way (Search for Log shipping in BOL).
There are different ways of setting it up as well, you
could use .bat files, with backup, copy and restore
commands and have it run by sql jobs at an interval which
you desire.
Note that, this would just restore to your backup server
and you may want to work on user permissions and re-
pointing your applications to the new server (if the main
goes down) -- however, unlike clustering, this is not
automatic and may require downtime.
Also look for Failover Clustering in BOL.
Thanks,
Mark
>--Original Message--
>I would like to know how I can synchronize my SQL
Databases between two servers. These two servers are in
two different places and both are running SQL 2000 on a
Windows 2000 Server.
>Scenario:
>One of these servers is my active one right now which is
working as a web server for my hosting company. I would
like to add my second server as DNS2 for my hosting
clients so if incase the DNS1 (my current active server)
failed, the DNS2 comes to play and provide my clients the
same information as DNS1.
>Any help would be greatly appreciated!
>Thanks,
>Mike
>.
>