RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
MirrorTypes Class

Contains the valid values for the TYPE column from DB_ADMIN.GET_MIRRORS stored procedure.

Pascal
MirrorTypes = class;
C++
class MirrorTypes;

MirrorTypes.cs

MirrorTypes contains the valid values for the TYPE column from DB_ADMIN.GET_MIRRORS stored procedure. These values are also found in the system table SYS.SYSMIRRORS. 

The valid values are:

Constant 
Description 
NONE  
Mirroring not enabled.  
PRIMARY  
There is only one primary mirror. It is the only mirror that supports any form of write operation on the database.  
READONLY  
There can be one or more READONLY
MIRRORS. READONLY mirrors support read operations, but not write operations. READONLY mirrors provide a view of the PRIMARY database at the point in time they were last synchronized with the PRIMARY.  
DIRECTORY  
There can be one or more DIRECTORY MIRRORS. DIRECTORY mirrors support read operations, but not write operations. A DIRECTORY mirror mirrors the SYS.MIRRORS table, but not the data itself. Connection requests to a DIRECTORY mirror are redirected to the PRIMARY mirror if a writable connection is needed. Otherwise a load balancing algorithm is used to decide which READONLY mirror should be used for the connection.  

 

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!