ReplicationServer.EnumCurrentPrincipals 메서드

Returns information for all published databases that are participating in database mirroring.

네임스페이스:  Microsoft.SqlServer.Replication
어셈블리:  Microsoft.SqlServer.Rmo(Microsoft.SqlServer.Rmo.dll)

public DataSet EnumCurrentPrincipals()

반환 값

유형: System.Data.DataSet
A DataSet object that contains the following columns.

Column

Data type

Description

db_name

sysname

Database name.

current_principal

sysname

The current principal for the mirrored database.

mirroring_role

tinyint

Current role of the local database plays in the database mirroring session.

1 = Principal

2 = Mirror

NULL = Database is not online.

mirroring_state

tinyint

State of the mirror database and of the database mirroring session.

0 = Suspended

1 = Disconnected

2 = Synchronizing

3 = Pending Failover

4 = Synchronized

NULL = Database is not online.

This method is used to support replication with database mirroring. For more information, see 데이터베이스 미러링 및 복제(SQL Server).

커뮤니티 추가 항목

추가
표시: