Posted by Mike Epprecht \(SQL MVP\) on 07/11/05 07:07

Hi

Log shipping is the least intrusive as it requires no table changes.

Replication, IMHO, is a bad form of DR as you can not be guaranteed the time
lag between the primary and secondary being updated.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"New MSSQL DBA" <boscong88@gmail.com> wrote in message
news:1121049035.357996.61730@g49g2000cwa.googlegroups.com...
> hi all, I am considering what should be the best way of implementing
> the following requirement.
>
> I've got a SQL2K production server. Now I've got another machine as the
> standby machine for this server
> so I'm thinking what method should I be using for this.
>
> Should I be using log shipping or Replication? Or if it's replication,
> what kind of replications
> should it be?
>
> I am thinking maybe snapshot replication can be just fine, right?
>

• Next in forum: Re: T-SQL how to deal with results from stored proc
• Prev in forum: SQL Replication Question
• Thread view: Re: Method of providing standby

[Reply to this message]