Backup of database from one server to another

[silicon]

I have Hospital Management Software.The platform is VB6.0 and SQL Server.In this s/w i have around 1500 tables.The s/w is networked.I have two server one is primary server and another is backup server.I want that when my application is running ,the data to be stored in primary as well as backup server.How can i do in Sql Server.I have heard of Replication in SqlServer.How to implement this.
Thanks

 

[tlbroadbent]

Start with SQL Books Onliine and read about replication.

Replication Overview

http://msdn.microsoft.com/library/en-us/replsql/replover_694n.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.