Partilhar via

DatabaseOptions.MirroringRedoQueueMaxSize Property

  • Artigo

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
Public Property MirroringRedoQueueMaxSize As Integer

public int MirroringRedoQueueMaxSize { get; set; }

public:
property int MirroringRedoQueueMaxSize {
    int get ();
    void set (int value);
}

/** @property */
public int get_MirroringRedoQueueMaxSize ()

/** @property */
public void set_MirroringRedoQueueMaxSize (int value)

public function get MirroringRedoQueueMaxSize () : int

public function set MirroringRedoQueueMaxSize (value : int)

Property Value

A Integer value that specifies maximum size of the redo queue of the mirror server instance in KB.

Remarks

Updated text:5 December 2005

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.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Get and Set a Property in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

DatabaseOptions Class
DatabaseOptions Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Database Mirroring
Setting Properties
Database Options
ALTER DATABASE (Transact-SQL)