Re: Log Shipping or Replication

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/01/05 

Date: Mon, 31 Oct 2005 20:02:22 -0700

It depends on a lot of things. You can get started with the
high availability options discussed in this chapter in the
Resource Kit:
Chapter 15 - High Availability Options
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part1/c0161.mspx

There is also some information in the following KB article:
Disaster recovery options for Microsoft SQL Server
http://support.microsoft.com/?id=822400

-Sue

On Mon, 31 Oct 2005 16:46:34 -0500, "Gabe Matteson"
<gmatteson@inquery.biz.nospam> wrote:

>Which would you recommend to setup as a failover database server? (We do not
>have the ability right now to setup a sql cluster). What is the difference
>between log shipping and database replication? Pros/Cons? Thanks.
>- Gabe
>

Loading