sql server dts: Log Shipping or Replication -- sql server dts

Re: Log Shipping or Replication

Sue Hoegemeier
10/31/2005 8:02:22 PM

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"
[quoted text, click to view]

Re: Log Shipping or Replication

Ole Kristian Bangås
10/31/2005 11:11:31 PM

"Gabe Matteson" <gmatteson@inquery.biz.nospam> wrote in
news:OIonzPm3FHA.1596@tk2msftngp13.phx.gbl:

[quoted text, click to view]

Neither log shipping nor replication supports automatic failover. If
failover is a concert to you, and you cannot implement a cluster, I would
strongly suggest that you have a look on the database mirroring feature of
SQL Server 2005.

--
Ole Kristian Bangås

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.