I was curious if anybody had any experience replicating a Navision database to a DR site over a T1 (or bonded t1's) running SQL Server 2008 R2. Is there any software you use to do this and bypassing SQL's replication technologies and why or do you have something that integrates with SQL that improves the performance across slow links? I would like just a one way setup, its for disaster recoveries only.
Here is an addition that would make it a lot nicer if it supported this as well. I have the NAV database and I have another database for my warehouse management system, i would like to replicate both of those servers to a single server in the DR site, all one way data though.
I should be pushing about 30MB-100MB every 10 minutes roughly depending on usage, that would be uncompressed data.
Question
NiteJammin
I was curious if anybody had any experience replicating a Navision database to a DR site over a T1 (or bonded t1's) running SQL Server 2008 R2. Is there any software you use to do this and bypassing SQL's replication technologies and why or do you have something that integrates with SQL that improves the performance across slow links? I would like just a one way setup, its for disaster recoveries only.
Here is an addition that would make it a lot nicer if it supported this as well. I have the NAV database and I have another database for my warehouse management system, i would like to replicate both of those servers to a single server in the DR site, all one way data though.
I should be pushing about 30MB-100MB every 10 minutes roughly depending on usage, that would be uncompressed data.
---------
|SQL 1| -----------------------
--------- \ ----------------
----> | DR Server |
--------- / ----------------
|SQL 2|------------------------
---------
Link to comment
Share on other sites
0 answers to this question
Recommended Posts