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

The SQL server 2005 mirror mode (asyn or syn)

Dear all,

Anyone know, if I configure the SQL mirroring via UI, database properties windows, what mode is the mirror? Async or sync?

It seem that I can't see any option like this in the UI when I set the mirror up.

  • 2
1 Solution
marrowyungAuthor Commented:
Any way to configure the mirror from UI to use Asyc mode?
DBAduck - Ben MillerPrincipal ConsultantCommented:
I can tell you that Async mode is only available in Enterprise Edition SP1 for 2005.  So if you have that, then you can configure it.

If you don't have that edition, then it makes sense that you would not have that option to choose from.
marrowyungAuthor Commented:

Today I just figure it out myself, that's exactly what I found out also and we are using standard edition.

and I also surprise that we can only change the mode to Async once the DB is mirrored, but not before it is mirrored.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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