Hello,

I'm searching for information on replicating DB for disater recovery.  I
read online that some people do not recommed the SQL Server replication
procedure.  Can you recommend a software or a good way to replicate DB to
remote server?

Thanks.

You can use Database Mirroring (SQL Server 2005 or later) or Log Shipping.

More about Database Mirroring:
http://msdn.microsoft.com/en-us/library/ms188712.aspx
http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx
http://www.sql-server-performance.com/articles/clustering/mirroring_2005_p1.aspx

More about Log Shipping:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx
http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx

Database mirroring for a remote site is probably not a good idea.

Log shipping is much more acceptable though.


Plamen Ratchev wrote:
Show quoteHide quote

Depends. We have remote sites with very good connectivity where database
mirroring is preferred because of the automatic failover capabilities.

I've seen mirroring, log shipping and replication used for DR in my last 2
contracts and each has its own particular advantages and disadvantages.  For
your case there are some key questions that should help to narrow down the
appropriate technologies:
Do you require automatic failover?
What is the minimum latency you can afford?
Is the DR site to be used for reporting as well?
Do you have a reasonable amount of time to administer it?
What version/edition of SQL Server are you using?
Do you have an extra server which could be used as a witness?
If you can answer these, then we'll be able to better help you out.
Cheers,
Paul Ibison

One thing that you need to understand is that replication was originally not
designed as a disaster recovery solution.  It is a means to bring the data
nearer to the data consumer. In SQL Server 2000, for example, since log
shipping is not available in Standard Edition, a lot of people use
replication as a disaster recovery solution but should take the risk of not
having the same database schema as that of the primary database


Show quoteHide quote

Cursor Help
Disaster Recovery Options
Problem in sysdatabases
Is it possible to associate sql login with network address?
SQL Server 2005 Script Out User Permission Prod-> Dev
FT Index - Avoid Noise Words
how to ignore error....
Defrag SQL Server Files
recovery mode help ?
SQL Server 2005 Rebuild Error: 8152