January 15, 2004 at 8:40 am
I want to setup some sort of replication for a database that is approx. 170GB. We want a warm standby in case the production server has problems. What would be the best way to handle this? Is log-shipping an option? Publish/Subscribe? We're running SQL 2K sp3 and this will be my first attempt to setup any type of replication so evidently, all suggestions will be greatly appreciated! And please include as much detail as you can. Thanks.
Terry
January 15, 2004 at 9:13 am
Both log shipping and replication could be good choices, but better cluster server of course.
If you are going to use replication then I would suggest to use Transactional.
You can create several publications depending on the load of tables. For tables that are modified every time create one publication and replicate it continuosly or in short times, and then create another publication for tables that are not updated so often and replicate them on a regular basis but not all the time, to reduce workload.
If the server is eavely accessed, then you might consider separating the distributor into another fisicall server.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply