locked
SQL Server 2008 Replication RRS feed

  • Question

  • Hi there guys,

    Can someone teach me on how do i replicate our database server. I'm just new with MS so please guide me. Thanks you.

    Best Regards,

    Albie Bokingkito Jr.
    Systems Administrator

    Friday, October 22, 2010 1:48 AM

Answers

  • We need a few more requirements.  Do you want to replicate the entire database server or just user defined databases?  Do you want any kind of failover?  How much, if any, data loss is acceptable in the event of a disaster?

    This will get you started, use a search engine to find out more info.  You really have two general types of replications with many options within each type.

    Replication that is defined per database

    - Transactional Replication, Database Mirroring and Log Shipping are some technologies that you can investigate to keep user defined databases in sync.  These technologies are not used to keep things like master database files and SQL Agent jobs in sync.  Here might be a good place to start reading.

    http://technet.microsoft.com/en-us/library/bb522583.aspx

    Replication that is defined per instance

    - This generally means block level replication from storage vendors (EMC, HDS, etc) or 3rd party software replication (Double-Take, SteelEye) vendors that keep everything in sync at the block level.  Some of these solutions can also integrate with Microsoft Windows Server Failover Clusters to form what are known as Multi-Site Clusters.

    - Of course if you move it up a layer and are running your SQL Server instance in a VM you can also consider replicating the entire VHD file with one of the block based replication solutions mentioned above as well.


    David A. Bermingham, MVP Senior Technical Evangelist, SteelEye Technology
    • Proposed as answer by Tom Li - MSFT Tuesday, October 26, 2010 7:43 AM
    • Marked as answer by Tom Li - MSFT Monday, November 1, 2010 9:17 AM
    Saturday, October 23, 2010 12:48 AM

All replies

  • We need a few more requirements.  Do you want to replicate the entire database server or just user defined databases?  Do you want any kind of failover?  How much, if any, data loss is acceptable in the event of a disaster?

    This will get you started, use a search engine to find out more info.  You really have two general types of replications with many options within each type.

    Replication that is defined per database

    - Transactional Replication, Database Mirroring and Log Shipping are some technologies that you can investigate to keep user defined databases in sync.  These technologies are not used to keep things like master database files and SQL Agent jobs in sync.  Here might be a good place to start reading.

    http://technet.microsoft.com/en-us/library/bb522583.aspx

    Replication that is defined per instance

    - This generally means block level replication from storage vendors (EMC, HDS, etc) or 3rd party software replication (Double-Take, SteelEye) vendors that keep everything in sync at the block level.  Some of these solutions can also integrate with Microsoft Windows Server Failover Clusters to form what are known as Multi-Site Clusters.

    - Of course if you move it up a layer and are running your SQL Server instance in a VM you can also consider replicating the entire VHD file with one of the block based replication solutions mentioned above as well.


    David A. Bermingham, MVP Senior Technical Evangelist, SteelEye Technology
    • Proposed as answer by Tom Li - MSFT Tuesday, October 26, 2010 7:43 AM
    • Marked as answer by Tom Li - MSFT Monday, November 1, 2010 9:17 AM
    Saturday, October 23, 2010 12:48 AM
  • Perhaps you had in mind Clustering?

    http://technet2.microsoft.com/windowsserver/en/library/32c40202-1043-4211-8dba-bb57356f46811033.mspx?mfr=true  ---All about CLustering


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, October 24, 2010 7:48 AM