90GB database replication over VPN (WAN) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

90GB database replication over VPN (WAN)

Hi,
I have interesting challenge in front of my face – I need to enable replication of 90GB SQL 2000 database between two sites connected with VPN link. The current link speed is 1Mb, but can be quickly upgraded if required. It doesn’t have to be continuous replication – 1h difference between two synchronizations is acceptable. The daily database changes are around 1GB. Apart from data changes, the database layout (tables, columns) also changes quite frequently. Now I wonder which solution would be the best in my case. I consider built-in SQL replication; however, I think it may not be sufficient over VPN connection. What more, as far as I’m aware, there are several restrictions on that – it will not(?) replicate database changes. I’m not sure if Log Shipping will help me either. There are other 3rd party applications that support that task.
I had a look at SQL Data Compareâ„¢ Standard, I know Veritas and Legato also offer something.
Any recommendations? Thanks,
Daniel

If there are schema changes to the databases, then I wouldn’t suggest replication is suitable. Though you can continue the replication without refreshing, but sometime it will create further hurdle in completing the transactions. How often the database is used on the Second site? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Well, the database is not used very frequently – that machine is a disaster recovery server, used only in case of a serious failure on the production server. But, management wants to have it up to date all the time, and I need to solve it.
Then I would suggest to go with RESTORE TRANSACTION LOGS periodically or log shipping during specific timings. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
All right, thanks,
but will it solve database schema changes???
Yes as the Log Shipping will take care of all the database changes from primary to secondary, take your time to read Books Online and this website about Brad McGeeHee article on LS. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Sounds great, thanks a lot!
]]>