• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

SQL 2005 Mirroring - Which Version?

We want a highly fault tolerant SQL 2005 solution. Rather than using a cluster we have been told (among other things) that using SQL's mirroring capabilities would be the best answer. One vendor advocates Standard Edition and the other says we need Enterprise Edition.

What we want is a highly fault tolerant solution that will fail over (and back) without user intervention. We will only have less than 10 users and it isn't a very complex database application. We will be using 2 - 1.7ghz single processor servers with 4gb memory and multiple hard drives and an exhisting fault tolerant server as the witness.

Can someone further explain the dangers/benefits to using the 2 versions? Remember the failover has to be automatic.

Thanks
0
alnish
Asked:
alnish
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>What we want is a highly fault tolerant solution that will fail over (and back) without user intervention.
the problem to fail back eliminites the mirroring solution, as he failback requires to setup the mirroring into the other direction (manually).

only clustering will provide you the failover + failback that way.
however, that requires shared disk space.

the mirroring has the advantage of not requiring shared disk space...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now