SQL Server Replication/Mirroring

[ababbitt]

I am looking to develop a mirrored database system wherein two database servers would be Publisher/Subscriber. Is it possible to Replicate/Mirror SQL Server 7.0 databases without additional software?


I am really just looking for a confirmation that my assumptions are correct.

Thanks in advance.

 

[sguslan]

If you are stuck with sql 7, then replication will do just that if your database is of a moderate size. I already have been doing that for 2 years, but i am replicating a few tables with about 60000 new records a day. Otherwise, you can try log shipping in sql2000, it should be better suited.

Read on :

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

http://www.swynk.com/friends/achigrik/SetupMR.asp

http://www.swynk.com/friends/achigrik/setupSR.asp