Groups | Blog | Home
all groups > sql server replication > march 2006 >

sql server replication : SQL2005


mecn
3/23/2006 5:43:16 PM
Hi,

First time for me installing sql2005 in production.
Question that i have is that should I continue using log shipping to standby
server or I should use sql2005 replication?
Thnakl

Hilary Cotter
3/23/2006 8:26:53 PM
That depends on your requirements. Log shipping replicates the entire
database - including system objects. Replication replicates all user data
and schemas, but you can select what you want to replicate.

With Log shipping your destination database must go offline as you apply
the log. With replication your subscriber can be available for useful work.
With replication you can massage the data in-flight-log shipping is an exact
copy.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Paul Ibison
3/24/2006 12:00:00 AM
Please take a look at this article for some more info:
http://www.replicationanswers.com/Standby.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button