Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2003
    Posts
    10

    Question Unanswered: Database Replication

    I'm a newbie so bare with me. If I have two servers running SQL Server, a primary and a secondary, how can I make sure that both databases (One on each server) are always syncronized? In our situation the secondary server is a hot backup in case the primary fails. If the primary fails then data gets written to the secondary. When the primary comes back up then its database needs to be synced with the secondary. Can anyone tell me how to do this?

  2. #2
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149

    Wink

    Have a look on books online about Transactional Replication...

    This is a form of replication that will make your two server in sync.

    Any changes that are made on one server are automatically replicated over to your other server.


    http://www.databasejournal.com/featu...le.php/1438201


    http://www.sql-server-performance.co...eplication.asp


    Hope this helps mate

  3. #3
    Join Date
    Jul 2003
    Posts
    10
    Thanks for the links! Do you know if you are doing transactional replication, if the other server is down, will the server que the transactions and keep trying to send them until it succeees?

  4. #4
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    no,

    As far as I know it will publish on an all or nothing basis.

    If your primary server goes down then replication will stop because it has no server to replicate to (i.e no subscribers)

    This is the time you flip the primary to your hot spare and fix the original server. After you have sorted the problem on the original server just kick off replication again.

    Cheers

  5. #5
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    Why don't you create a 2 node cluster?

  6. #6
    Join Date
    Jul 2003
    Posts
    10
    Not using Enterprise. I don't think it is available on standard.

  7. #7
    Join Date
    May 2003
    Location
    Atlanta, GA
    Posts
    187
    You're right, Only on Enterprize.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •