Sdílet prostřednictvím


DatabaseOptions.MirroringRedoQueueMaxSize Property

Gets or sets the maximum size of the redo queue of the mirror server instance in KB.

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

Syntax

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

value = instance.MirroringRedoQueueMaxSize
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int MirroringRedoQueueMaxSize { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int MirroringRedoQueueMaxSize {
    int get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member MirroringRedoQueueMaxSize : int
function get MirroringRedoQueueMaxSize () : int

Property Value

Type: System.Int32
An integer value that specifies maximum size of the redo queue of the mirror server instance in KB.

Remarks

The redo queue includes the log records waiting to be rolled forward on the mirror database. By default, the size of the redo queue is unlimited. You can specify the property on the principal server only.

Examples

Setting Properties

See Also

Reference

DatabaseOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Database Mirroring Administration

Database Options

ALTER DATABASE (Transact-SQL)