Data Replication

[maqsoodjee]

Hi

Can any one tell me is there any why like to setup SQL Backup Server just like BDC in windows NT Server...... so my SQL main Server Goes Down then my SQL Backup Server will Serves the User Request ..its means My all Main SQL Server's Databases will replicate with my Backup Server automaticaly

Looking forward for the good responces

 

[sguslan]

Search SQL books Online for "log shipping". The other option is replication but i would advise to take the log shipping route as it is more suitable for creating stand by servers.

You can find more information on replication at

http://www.sql-server-performance.com/replication_tuning.asp

and information on log shipping at

http://www.sql-server-performance.com/sql_server_log_shipping.asp