April 7, 2017 at 11:57 am
In my organization we have an outside CRM that replicates a read only copy of our database to us via RedGate Log Shipping. I have experience in the past with managing SQL Servers, however I don't have any exposure to RedGate as a product. The problem is that often logs are delivered to us out of sync, or not at all, causing a number of issues that make this data source unavailable. This has become increasingly unacceptable as we write more reports\processes against this dataset. However, our CRM provider refuses to improve the current process, or modify it in any way.
So, what I am wondering, is it possible to leave this process in place and add a separate SQL Instance that does true replication. That doesn't solve the problem of having the data any more up to date, but at least it would provide a highly available server instance that can be relied on.
Where I'm stuck is understanding if a replication between the two internal SQL Servers would potentially break or further hinder the log shipping to what would essentially be the Publisher of the relationship.
I am also open to other solutions that may solve the availability problem.
Regards
April 10, 2017 at 8:04 am
If they are having trouble managing the logs, log files and log backups, regardless of the fact that Redgate Software is being used to do the backups & restores (DISCLOSURE: I work for Redgate. From what you're saying, we're not the problem here, for log shipping to work, the logs have to be received and in the correct order, that's just how it works within SQL Server, whether we manage it for you or not), then adding replication to the mix could, potentially, make things worse. If replication goes offline, you'll get bigger transaction logs and log backups since it will have to wait until you get replication back online. You'd be better served by figuring out what they're doing wrong with the log shipping and getting that fixed than adding yet another layer, and another failure point, to the process.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply