مشاركة عبر


DatabaseOptions.MirroringTimeout Property

Gets or sets the maximum time, in seconds, that the principal server instance waits for a PING message from another instance in the mirroring session before assuming the other instance is disconnected.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property MirroringTimeout As Integer 
    Get 
    Set
'Usage
Dim instance As DatabaseOptions 
Dim value As Integer 

value = instance.MirroringTimeout

instance.MirroringTimeout = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int MirroringTimeout { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int MirroringTimeout {
    int get ();
    void set (int value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member MirroringTimeout : int with get, set
function get MirroringTimeout () : int 
function set MirroringTimeout (value : int)

Property Value

Type: System.Int32
An Integer value that specifies the mirroring time-out period, in seconds, on the principal server instance.

Remarks

The default value for the MirroringTimeout property is 10 seconds. If you specify 5 or greater, the time-out period is set to the specified number of seconds. If you specify a time-out value of 0 to 4 seconds, the time-out period is automatically set to 5 seconds.

Examples

Setting Properties

See Also

Reference

DatabaseOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Database Mirroring Administration

Database Options

ALTER DATABASE (Transact-SQL)