marrowyung
asked on
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.
DBA100.
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.
DBA100.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ahaha.
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.
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.
ASKER