November 29, 2007 at 8:36 am
My company is harvesting data from the sql server databases serving a 3rd party application.
Transaction replication is out because the application does not have primary keys and I have been given hands off the database instructions.
CommVault has a Block-Level replication that they promote for Sql Server replication.
a) has anybody used this tool?
b) CV is tracking file block-level changes for their replication. If the database has the indexes rebuilt would that cause a large change in the block-level?
thanks
Daryl
November 29, 2007 at 12:58 pm
Haven't used CV, but we are using a similar product called WanSync for DR. Same sort of thing - monitors block-level activity. Rebuilding indexes would create a lot of block-level changes, so that would be a lot of data to be replicated.
Is log shipping an option? What version/edition of SQL Server are you using?
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
November 29, 2007 at 1:39 pm
The source (3rd party app usage) sql server is 2000. The warehouse is 2005.
I have not looked into log shipping, will investigate.
thanks for the new direction.
daryl
November 29, 2007 at 5:19 pm
We looked at the CommVault block level replication a few years ago. At the time, we were trying to replicate changes in Word documents, not SQL data. It didn't work as well as they claimed. That being said, I heard a new version is out and is better. You also may want to look at the Microsoft offering : System Center : Data Protection Manager. I have not used it, just heard the sales blurbs.
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply