Link to home
Start Free TrialLog in
Avatar of MohitPandit
MohitPanditFlag for India

asked on

SQL Server 2005: Advantages and Disadvantages Replication and Log shipping

Hello,

Can anyone put stamp for advantage and disadvantages for replication and log shipping?

Best Regards,
MohitPandit
Avatar of rbride
rbride

Replication would be used to transfer parts of a database, such as individual tables, also to respond to particular events. Replication can also be used between heterogenous systems. The subscribing system can be both read AND write.

Log shipping would be used when you want a standby database system. You have a second server and load transaction logs at regular intervals. This secondary database can only be read only.
Avatar of MohitPandit

ASKER

Actually, I've one server A and I want to synchronize with another server like B. All historical data will be on Server B and will be used for reporting purpose only.

The server A will be having 1 year historic data only.

I am planning to implement transactional replication. Can you please provide me a list of Assumptions (i.e. Software/network requirements) and advantages/disadvantages for transaction replication?
And I need to copy daily incremental data from Server A (around 25 tables' data) to Server B.
I apologize, it would not helpful actually.

Like, I aforesaid in second and third comments; I will implement transaction replication.

So, can you please provide below things?

a.      Assumptions (including Software/Network Requirements)
b.      Advantages
c.      Disadvantages

NOTE: the subscriber server can be on across domain as well.

Can you please assist on it?
ASKER CERTIFIED SOLUTION
Avatar of rbride
rbride

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks