Log Shipping vs. Replication?

Log Shipping vs. Replication?

Post by googlenew » Sat, 20 Dec 2003 07:27:27


Or, really, is log shipping the right choice for the following
situation:

The production server (A) must be highly available throughout the day
to its users. There are also some reporting tasks that run throughout
the business day that slow things down a bit. These tasks are to be
offloaded to a second SQL Server (B).

I've setup log shipping from A to B (B in STANDBY mode) every 5
minutes and gotten this to work fairly consistently. The reporting
jobs run off server B well, too. However, the reporting jobs appear to
interfere with the replication.

I leave server B alone, replication runs fine. As soon as I access
server B for anything, replication stops working they become out of
sync. If I close all connections to server B again, replication seems
to pick back up.

My assumption is that the connections to server B are stopping the
server B from being able to restore new transaction logs. Is this
correct?

The problem being partially that the reports run through an ASP.NET
application, which pools connections to server B in ADO.NET... this
the connection remains longer than the actual queries. To test my
theory, I did an IISRESET after I was done running some reports,
effectively closing all connections, and that is when log shipping
picked up again.

My end goal in THIS scenario is to have server B contain very recent
data from server A (a lag time of 5-10 minutes is acceptable) and
allow queries to be run against server B. No modifications of data
will be made to server B.

What is the best way to implement this with the minimal performance
impact on server A and server A's users? I am think that transactional
replication will be the way to go. The servers are in the same rack
and we want updates to server B to be as recent as possible compared
to when they occur on server A.
 
 
 

1. db2 replication vs log shipping

2. MCMS & Transactional Replication vs. Log Shipping

Hi all,

There is plenty of information saying that SQL replication is not
supported with MCMS but log shipping is. I am confused as to WHY?
What is the difference to MCMS 2002 Sp1a between SQL Transactional
Replication and Log Shipping? It seems to me that at the end of the
day both are transaction-safe so what's the problem? I know MS will
say 'potential node cache inconsistencies' but what causes these
inconsistencies when replication is used that doesn't happen when log
shipping is?

TIA,

Chandy

3. replication & log shipping

4. transactional replication and log shipping

5. Replication with Log Shipping

6. log shipping and replication

7. Database Mirroring and Replication OR Database Mirrroing and Log Shipping

8. Replication, Log Shipping and Backup

9. Log Shipping for replication

10. replication and log shipping

11. Replication or Log shipping

12. Log Shipping target, transactional replication source

13. Replication v Log Shipping

14. using replication versus log shipping

15. Replication v Log Shipping