MohitPandit
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
Can anyone put stamp for advantage and disadvantages for replication and log shipping?
Best Regards,
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?
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?
ASKER
And I need to copy daily incremental data from Server A (around 25 tables' data) to Server B.
ASKER
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
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.