SQL Server Performance

90GB database replication over VPN (WAN)

Discussion in 'Performance Tuning for SQL Server Replication' started by Danny_W, Jun 2, 2006.

  1. Danny_W New Member

    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
  2. satya Moderator

    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.
  3. Danny_W New Member

    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.
  4. satya Moderator

    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.
  5. Danny_W New Member

    All right, thanks,
    but will it solve database schema changes???
  6. satya Moderator

    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.
  7. Danny_W New Member

    Sounds great, thanks a lot!

Share This Page