Member Avatar for mherz

Good day,

I need some advise. I have two database servers(primary & secondary) and both has installed the MS SQL Server 2008 r2.
The idea is, the secondary server should setup as standby in case the primary servers down.
How do I set it up?

thanks in advance.

  • 2 Contributors
  • 1 Reply
  • 165 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by hericles
Member Avatar for hericles

Look into replication. It allows you to set up a primary and secondary server, the secondary receiving changes from the primary. With two servers set up this way you would need to manually switch the secondary to the primary role. To have it happen automatically you need a third server (called the witness) which polls the other 2 to ensure the primary is functioning.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.