SQL Server Performance

Two identical SQL databases

Discussion in 'Performance Tuning for SQL Server Replication' started by BugMe, Sep 5, 2006.

  1. BugMe New Member

    I have two identical databases that each of them resides on different servers. One of them serves as the primary database where the users are connected to. I need to make the secondary database on the other server to be the same as the primary database. In other words, the data on both machines need to be the same up to minute. Any ideas and suggestions as how to make this happen?

    Thanks

    Bugme
    BugMe, Sep 5, 2006
    #2

  2. Luis Martin Moderator

    Take a look of replication in Books on Line.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Sep 5, 2006
    #2

  3. satya Moderator

    If you want the secondary database as a warm standby and read-only until the time of restore you can take help of Log shipping.

    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.
    satya, Sep 6, 2006
    #2

Share This Page