SQL Server Performance

Help to choose best replication

Discussion in 'SQL Server 2005 Replication' started by sramesh, May 15, 2007.

  1. sramesh New Member

    Hi All,
    I have configured failover cluster. My manager is asking to replicate all database to other on server which is not in same domain.

    I want replication as same as original database to another one server.
    The new server is used to diaster recovery. Which replication method is best?
    Are Some other methods available other than replication?

    I am using SQL Server 2005 Enterprise Edition.


    Thanks
    S. Ramesh
  2. techbabu303 New Member

  3. satya Moderator

    Why don't you take help of database mirroring in this case to addup additional layer of availability to the current cluster environment.

    Is there any specific reason to go for replication only?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  4. MohammedU New Member

    Transactional replication is the best method but you have to have PK to replicate...

    You can take the help of Database mirroring or log shipping but the databases will not be available to read all the time for any other purposes like reporting...

    Cluster helpful only when there is a problem with the server but not with disk...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  5. thomas New Member

    As Mohammed and Satya have said, Replication is not really a high availability solution [unless it's peer-ro-peer replication, which yours wouldn't be]. Definitely you need to go for database mirroring or log shipping. If you have SQL Server 2005 Enterprise Edition you can create snapshots of the mirrored database for reporting if you want.
  6. sramesh New Member

    Thanks for all your help. I am going to install database mirror.

    Thanks
    S. Ramesh
  7. satya Moderator

    For the sake of budgets you can even get rid of cluster if the database mirroring had setup properly without any issues.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page